Need help with this: Answer each of the following questions using the KimTay Pet Supplies data shown in Figure 1-2. No computer work is required. 1. List the first and last names of all customers that have a credit limit above, but not including, $500. 2. List the invoice numbers for invoices placed by customer ID 435 on November 18, 2021. 3. List the item ID, item description, and on-hand value for each item in category HOR. (Hint: On-hand value is the result of multiplying the number of units on hand by the price.) 4. List the item ID and item description of all items that are in category DOG. 5. How many customers have a balance that exceeds their credit limit? 6. What is the item ID, description, and price of the least expensive item in the database? 7. For each invoice, list the invoice number, invoice date, customer ID, and customer first and last names. 8. For each invoice placed on November 16, 2021, list the invoice number, customer ID, and customer first and last names. 9. List the sales rep ID, and first and last names, for every sales rep who represents at least one customer with a credit limit of $1,000. 10. For each invoice placed on November 15, 2021, list the invoice number, item ID, item description, and category for each item ordered.
Need help with this:
Answer each of the following questions using the KimTay Pet Supplies data shown in Figure 1-2. No computer work is required.
1. List the first and last names of all customers that have a credit limit above, but not including, $500.
2. List the invoice numbers for invoices placed by customer ID 435 on November 18, 2021.
3. List the item ID, item description, and on-hand value for each item in category HOR. (Hint: On-hand value is the result of multiplying the number of units on hand by the price.)
4. List the item ID and item description of all items that are in category DOG.
5. How many customers have a balance that exceeds their credit limit?
6. What is the item ID, description, and price of the least expensive item in the
7. For each invoice, list the invoice number, invoice date, customer ID, and customer first and last names.
8. For each invoice placed on November 16, 2021, list the invoice number, customer ID, and customer first and last names.
9. List the sales rep ID, and first and last names, for every sales rep who represents at least one customer with a credit limit of $1,000.
10. For each invoice placed on November 15, 2021, list the invoice number, item ID, item description, and category for each item ordered.
Trending now
This is a popular solution!
Step by step
Solved in 5 steps
