Question: Please answers the question no computer sql is required Exercises TAL Distributors Answer each of the following questions using the TAL Distributors data shown in

Please answers the question no computer sql is required  Please answers the question no computer sql is required Exercises TAL

Distributors Answer each of the following questions using the TAL Distributors data

shown in Figure 1-2. No computer work is required. 1. List the

Exercises TAL Distributors Answer each of the following questions using the TAL Distributors data shown in Figure 1-2. No computer work is required. 1. List the names of all customers that have a credit limit of $7,500 or less. 2. List the order numbers for orders placed by customer number 586 on 10/15/2015. 3. List the item number, item description, and on-hand value for each item in category TOY. (Hint: On-hand value is the result of multiplying the number of units on hand by the price.) 4. List the item number and item description of all items that are in category PZL 5. How many customers have a balance that exceeds their credit limit? 6. What is the item number, description, and price of the least expensive item in the database? 7. For each order, list the order number, order date, customer number, and customer name. 8. For each order placed on October 13, 2015, list the order number, customer number, and 9. List the sales rep number and name for every sales rep who represents at least one cus- 10. For each order placed on October 12, 2015, list the order number, item number, item customer name. tomer with a credit limit of $10,000. description, and category for each item ordered

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!