Find the number and name of each customer that currently has

Assignment Help Computer Engineering

Reference no: EM133368918

Use SQL and the TAL Distributors database (see Figure 1-2 in Chapter 1) to complete the following exercises. If directed to do so by your instructor, use the information provided with the Chapter 3 Exercises to print your output or save it to a document.

1. For each order, list the order number and order date along with the number and name of the customer that placed the order.

2. For each order placed on October 15, 2015, list the order number along with the number and name of the customer that placed the order.

3. For each order, list the order number, order date, item number, number of units ordered, and quoted price for each order line that makes up the order.

4. Use the IN operator to find the number and name of each customer that placed an order on October 15, 2015.

5. Repeat Exercise 4, but this time use the EXISTS operator in your answer.

6. Find the number and name of each customer that did not place an order on October 15, 2015.

7. For each order, list the order number, order date, item number, description, and category for each item that makes up the order.

8. Repeat Exercise 7, but this time order the rows by category and then by order number.

9. Use a subquery to 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.

10. Repeat Exercise 9, but this time do not use a sub query.

11. Find the number and name of each customer that currently has an order on file for a Rocking Horse.

12. List the item number, description, and category for each pair of items that are in the same category. (For example, one such pair would be item CD33 and item DL51, because the category for both items is TOY.)

13. List the order number and order date for each order placed by the customer named
Johnson's Department Store. (Hint: To enter an apostrophe (single quotation mark) within a string of characters, type two single quotation)

14. List the order number and order date for each order that contains an order line for a Fire Engine.

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.)

Reference no: EM133368918

Questions Cloud

Different meanings can cause problems for spell-checking : phonological ambiguity means that words that sound the same but have different meanings can cause problems for spell-checking tools

Which time you will sell the stock : which time you will sell the stock. You expect to be able to sell the stock for $35.00 at that time. If you want to earn an 8% return on this investment

Listening to text-compared to reading transcript : Listening to a text: use this topic to reflect on how listening to the BBC radio episode compared to reading the transcript.

How do developers decide how long a new user story : During Planning Poker, how do developers decide how long a new user story will take? Do the estimates have to be 100% accurate

Find the number and name of each customer that currently has : 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

How much money, in equal annual amounts, must be invested : You would like to have $5000 in savings at the end of 5 years. How much money, in equal annual amounts, must be invested at the end of each of the next five

How does achilles position change over the course : How does Achilles' position change over the course of the discussion? What does Achilles' return to battle after the death of Patrocles tell us about Achilles'

Provide a detailed description of the major hardware : Provide a detailed description of the major hardware and software components of the e-commerce company's hybrid information systems infrastructure.

What should be the stock price of rsm three years from now : What should be the stock price of RSM three years from now (right after the dividend at the time is paid)? What should be today's stock price of RSM?

User Account

All Pages