Task $3$: 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.

Task $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.$

Task $5$: Repeat Task $4,$ but this time use the EXISTS operator in your answer.

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

Task $7$: For each invoice, list the invoice number, invoice date, item ID$,$ description, and category for each item that makes up the invoice.

Task $8$: Repeat Task $7,$ but this time order the rows by category and then by invoice number.

Task $9$: Use a sub$-$query 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. From the textbook, A Guide to SQL $10$th edition