Use SQL Workbench. Module 5 KimTay Pet Supplies.

2. 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.

4. 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.

6. Find the ID, first name, and last name of each customer for which an invoice was not created on November 15, 2021.

8. Order the rows by category and then by invoice number

10. Do NOT 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.

12. 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.)

14. List the invoice number and invoice date for each invoice that contains an invoice line for a Wild Bird Food (25 lb).

16. List the invoice number and invoice data for each invoice that was created for James Gonzalez and that contains an invoice line for Wild Bird Food (25 lb).

18. List the item ID, description, unit price, and category for each item that has a unit price greater than the unit price of every item in category CAT. Use either the ALL or ANY operator in your query. (Hint: Make sure you select the correct operator.)