Exercises TAL Distributors Use SQL and the TAL Distributors database (see Figure 1-2 in Chapter 1)...

Transcribed Image Text:

Exercises TAL Distributors 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. List the item number, description, and price for all items. 2. List all rows and columns for the complete ORDERS table. 3. List the names of customers with credit limits of $10,000 or more. 4. List the order number for each order placed by customer number 126 on 10/15/2015. (Hint: If you need help, use the discussion of the DATE data type in Figure 3-16 in Chapter 3.) 5. List the number and name of each customer represented by sales rep 30 or sales rep 45. 6. List the item number and description of each item that is not in category PZL. 7. List the item number, description, and number of units on hand for each item that has between 20 and 40 units on hand, including both 20 and 40. Do this two ways. 8. List the item number, description, and on-hand value (units on hand * unit price) of each item in category TOY. (On-hand value is really units on hand * cost, but there is no COST column in the ITEM table.) Assign the name ON_HAND_VALUE to the computed column. Exercises TAL Distributors 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. List the item number, description, and price for all items. 2. List all rows and columns for the complete ORDERS table. 3. List the names of customers with credit limits of $10,000 or more. 4. List the order number for each order placed by customer number 126 on 10/15/2015. (Hint: If you need help, use the discussion of the DATE data type in Figure 3-16 in Chapter 3.) 5. List the number and name of each customer represented by sales rep 30 or sales rep 45. 6. List the item number and description of each item that is not in category PZL. 7. List the item number, description, and number of units on hand for each item that has between 20 and 40 units on hand, including both 20 and 40. Do this two ways. 8. List the item number, description, and on-hand value (units on hand * unit price) of each item in category TOY. (On-hand value is really units on hand * cost, but there is no COST column in the ITEM table.) Assign the name ON_HAND_VALUE to the computed column.

Answer rating: 100% (QA)

List the item number description and price for all items SELECT itemno description priceFROM item Li... View the full answer