KimTay Pet Supplies Use SQL and the Kim Tay Pet Supplies database (see Figure 1-2 in Module 1) to complete the following

[answerhappygod]

Kimtay Pet Supplies Use Sql And The Kim Tay Pet Supplies Database See Figure 1 2 In Module 1 To Complete The Following 1 (79.05 KiB) Viewed 27 times

KimTay Pet Supplies Use SQL and the Kim Tay Pet Supplies database (see Figure 1-2 in Module 1) to complete the following exercises. If directed to do so by your instructor, use the information provided with the Module 3 Exercises to print your output or save it to a document. 1. For each invoice, list the invoice number and invoice date along with the ID, first name, and last name of the customer for which the invoice was created. 2. 3. 4. 8. 9. For each invoice placed on November 15, 2021, list the invoice number along with the ID, first name, and last name of the customer for which the invoice was created. 5. Repeat Exercise 4, but this time use the EXISTS operator in your answer. 6. Find the ID, first name, and last name of each customer for which an invoice was not created on November 15, 2021. 10. 11. For each invoice, list the invoice number, invoice date, item ID, quantity ordered, and quoted price for each invoice line that makes up the invoice. 7. For each invoice, list the invoice number, invoice date, item ID, description, and category for each item that makes up the invoice. 12. Use the IN operator to find the ID, first name, and last name of each customer for which as invoice was created on November 15, 2021. Repeat Exercise 7, but this time order the rows by category and then by invoice number. Use a subquery to find the sales rep ID, first name, and last name of each sales rep who represents at least one customer with a credit limit of $500. List each sales rep only once in the results. Repeat Exercise 9, but this time do not use a subquery. Find the ID, first name, and last name of each customer that currently has an invoice on file for Wild Bird Food (25 lb). List the item ID, description, and category for each pair of items that are in the same category. (For example, one such pair would be item FS42 and item PF19, because the category for both items is FSH.)