Write the SQL query to get all the information of the French Customers with a credit limit between 75,000 and 100,000, values included MYSQL Sample Database Diagramproductlines*productLinetextDescriptionhtmlDescriptionimageproductsorderdetailsproductCodeproductNameproductLineproductScaleproductVendorproductDescriptionquantitylnStockbuyPriceMSRP* orderNumberproductCodequantityOrderedpriceEachorderLineNumberemployees* employeeNumberlastNamefirstNameextensionordersorderNumberorderDateemailcustomersrequiredDateshippedDateofficeCodereportsTojobTitlecustomerNumbercustomerNamestatuscontactl.astNamecommentscontactFirstNamecustomerNumberphoneaddressLine1officesofficeCodeaddressLine2citycityphoneaddressLine1addressLine2paymentscustomerNumbercheckNumberstatepostalCodecountrysalesRepEmployeeNumbercreditLimitpaymentDatestateamountcountrypostalCodeterritory主

Essential statements used in query: select: The select statement is used to select data from a…

MYSQL Sample Database Diagram productlines *productLine textDescription htmilDescription image products orderdetails productCode productName productLine productScale productVendor productDescription quantitylnStock buyPrice orderNumber productCode quantityOrdered priceEach orderLineNumber employees * employeeNumber lastName MSRP orders firstName orderNumber extension orderDate email customers officeCode reportsTo jobTitle requiredDate shippedDate status customerNumber customerName contactlastName contactFirstName phone comments customerNumber offices addressLine1 addressLine2 officeCode city phone addressLine1 addressLine2 state country postalCode territory city payments customerNumber state postalCode country salesRepEmployeeNumber checkNumber paymentDate creditLimit amount

MYSQL Sample Database Diagram productlines productLine textDescription htmilDescription image products orderdetails productCode productName productLine productScale productVendor productDescription quantitylnStock buyPrice orderNumber productCode quantityOrdered priceEach orderLineNumber employees employeeNumber lastName MSRP orders firstName orderNumber extension orderDate email customers officeCode reportsTo jobTitle requiredDate shippedDate status customerNumber customerName contactlastName contactFirstName phone comments customerNumber offices addressLine1 addressLine2 officeCode city phone addressLine1 addressLine2 state country postalCode territory city payments customerNumber state postalCode country salesRepEmployeeNumber checkNumber paymentDate creditLimit amount

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Write an SQL query using the UPDDATE and SET operator that willoverwrite all values containing 16 with 32 in the SupplierID attribute inthe Products table.
Write the SQL code that will change the PROJ_NUM to 14 for employees who were hired before January 1, 1994, and whose job code is at least 501. When you finish Problems 7–15, the EMP_2 table will contain the data shown in Figure P8.15.
Write a query in SQL code for: "List the book categories and the average book price of each category." Tablename is "BOOKS" and column names are: ISBN TITLE PUBDATE PUBID COST RETAIL DISCOUNT CATEGORY
Write SQL codes according to the requirements given. Tables are imaginary, column names can be made up. List the item ID, description, and category for each pair of items that are in the same category. (For example, one such pair would be item FS42 and item PF19, because the category for both items is FSH.) List the invoice number and invoice date for each invoice created for the customer James Gonzalez. Use a subquery to find the sales rep ID, first name, and last name of each sales rep who represents at least one customer with a credit limit of $500. List each sales rep only once in the results.
Write an SQL query to list the order number and order quantity for all customer orders for which the order quantity is greater than the average order quantity of that product. (Hint: This involves using a correlated subquery.)
I need to write a SELECT query in SQL using these instructions. Attached is the code that created the tables. SHOW name-of-tech part which are less than $300 and The Name of the Supplier. This will show which supplier has what parts under $300. FOR [Supplier] QUERY WILL USE: JOIN yes SUBQUERY no AGGREGATION no
Write SQL CODE List all the Course Code (CRS_CODE) that are taught by a Professor that does not hold "Ph.D." as the highest degree (based on PROF_HIGH_DEGREE in the PROFESSOR table).
Write an SQL query using a Wildcard operator that will show any ISBNstarting with 995 in the Books table. This query must also show the ISBNand the book title only.
Write a SQL code that returns the name of aircraft (MOD_NAME in MODEL table), number of trips each mode flied (based on the CHARTER table, name this Trip_Num), and Total distance of each mode (based on the CHARTER table, name this Total_Distance).
8) Display the firstname, lastname of the employees and the customerID that the employee served such that the employees are born after '1960-01-01'. Arrange the results by the last name. 6) Write a SQL query to output the product name and the quantity of the Orders of that product for those orders with more than 70 quantity. (hint: don’t have to use GROUP BY) NOTE: Please use only table joining to write the SQL quereys.
Include both SQL commands and SQL results in your answers: KimTay Pet Supplies is running a promotion that is valid for up to 20 days after an order is placed. List the invoice number, customer ID, customer first and last names, and the promotion date for each invoice. The promotion date is 20 days after the invoice was placed. Write PL/SQL (or MySQL) procedures to accomplish the following task: The procedure accepts the ID of a customer stored in the input variable named I_CUST_ID and displays the name (first name concatenated with last name) and credit limit of for this customer.
SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles Balance 500 350 800 100 SalesRepNo 345 434 654 345