Question about SQL Commands
Not what you're looking for?
See attach file for charts and data.
Use SQL, and the Premiere Products database (see Figure 1.2) to complete the following exercises.
1. For each order placed on October 20, 2003, list the order number along with the number and name of the customer that placed the order.
2. Use the IN operator to find the number and name of each customer that placed an order on October 20, 2003.
3. Find the number and name of each customer that did not place an order on October 20, 2003.
4. For each order, list the order number, order date, part number, part description, and item class for each part that makes up the order but order the rows by item class and then by order number.
5. Find the rep number, last name, and first name of each sales rep who represents at least one customer with a credit limit of $10,000. List each sales rep only once in the results. Do not use a subquery.
6. List the part number, part description, and item class for each pair of parts that are in the same item class.
7. List the order number and order date for each order that contains an order line for a Gas Range.
8. List the order number and order date for each order that was placed by Ferguline for a Gas Range.
9. List the part number, part description, unit price, and item class for each part that has a unit price greater that the unit price of every part in item class AP. Use either the ALL or ANY operator in your query. (Hint: Make sure you select the correct operator.)
10. For each part, list the part number, description, units on hand, order number, and number of units ordered. All parts should be included in the results. For those parts that are currently not on order, the order number and number of units ordered should be left blank. Order the results by part number.
Purchase this Solution
Solution Summary
The solution addresses about SQL command.
Purchase this Solution
Free BrainMass Quizzes
Excel Introductory Quiz
This quiz tests your knowledge of basics of MS-Excel.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.