Write the SQL query to get the order number, order date, customer name, shipped date, and sales representative employee number of the orders with status "cancelled" of the product line "Planes" and the quantity ordered was between 30 and 40, excluding the 30 and 40 values MYSQL Sample Database Diagramproductlines*productLinetextDescriptionhtmlDescriptionimageproductsorderdetailsproductCodeproductNameproductLineproductScaleproductVendorproductDescriptionquantitylnStockbuyPriceMSRP* orderNumberproductCodequantityOrderedpriceEachorderLineNumberemployees* employeeNumberlastNamefirstNameextensionordersorderNumberorderDateemailcustomersrequiredDateshippedDateofficeCodereportsTojobTitlecustomerNumbercustomerNamestatuscontactl.astNamecommentscontactFirstNamecustomerNumberphoneaddressLine1officesofficeCodeaddressLine2citycityphoneaddressLine1addressLine2paymentscustomerNumbercheckNumberstatepostalCodecountrysalesRepEmployeeNumbercreditLimitpaymentDatestateamountcountrypostalCodeterritory主

Since the data spans the following tables -orders -orderdetails -products -productlines -customers…

Answered: Write the SQL query to get the order…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Write the SQL query to get the order number, order date, customer name, shipped date, and sales representative employee number of the orders with status "cancelled" of the product line "Planes" and the quantity ordered was between 30 and 40, excluding the 30 and 40 values