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
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
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...
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
Transcribed Image Text:MYSQL Sample Database Diagram
productlines
*productLine
textDescription
htmlDescription
image
products
orderdetails
productCode
productName
productLine
productScale
productVendor
productDescription
quantitylnStock
buyPrice
MSRP
* orderNumber
productCode
quantityOrdered
priceEach
orderLineNumber
employees
* employeeNumber
lastName
firstName
extension
orders
orderNumber
orderDate
email
customers
requiredDate
shippedDate
officeCode
reportsTo
jobTitle
customerNumber
customerName
status
contactl.astName
comments
contactFirstName
customerNumber
phone
addressLine1
offices
officeCode
addressLine2
city
city
phone
addressLine1
addressLine2
payments
customerNumber
checkNumber
state
postalCode
country
salesRepEmployeeNumber
creditLimit
paymentDate
state
amount
country
postalCode
territory
主
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY