Question
Chapter 5 15. List the order number and order date for each order that either was placed by Almondton General Store or that contains an
Chapter 5 15. List the order number and order date for each order that either was placed by Almondton General Store or that contains an order line for a Fire Engine. 16. List the order number and order date for each order that was placed by Almondton General Store and that contains an order line for a Fire Engine. 17. List the order number and order date for each order that was placed by Almondton General Store but that does not contain an order line for a Fire Engine. 18. List the item number, description, unit price, and category for each item that has a unit price greater than the unit price of every item in category GME. Use either the ALL or ANY operator in your query. (Hint: Make sure you select the correct operator.) 19. For each item, list the item number, description, units on hand, order number, and number of units ordered. All items should be included in the results. For those items that are cur- rently not on order, the order number and number of units ordered should be left blank. Order the results by item number. 20. If you used ALL in Exercise 18, repeat the exercise using ANY. If you used ANY, repeat the exercise using ALL, and then run the new command. What question does the new command answer? 21. For each rep, list the customer number, customer name, rep last name, and rep first name. All reps should be included in the results. Order the results by rep number. There are two SQL commands for this query that will list the same results. Create and run each SQL command.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started