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

Question

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.

Explanation / Answer

Due to some issue with image upload, I am providing the excel output:

All Season Gifts

Only 1 customer i.e. Cards and More

Give A Thumbs Up!

Q.No. Answer 1) Toys Galore The Everything Shop Johnson's Department Store Grove Historical Museum Store Cards and More Cricket Gift Shop Unique Gifts

All Season Gifts

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.