Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Current Trends In Database Technology Edbt 2004 Workshops Edbt 2004 Workshops Phd Datax Pim P2panddb And Clustweb Heraklion Crete Greece March 2004 Revised Selected Papers Lncs 3268

Authors: Wolfgang Lindner ,Marco Mesiti ,Can Turker ,Yannis Tzitzikas ,Athena Vakali

2005th Edition

3540233059, 978-3540233053

More Books

Students also viewed these Databases questions