Task $5$: Write and execute the command to retrieve the item ID$,$ description, invoice number, and quoted price for all invoices in the ITEM$\_$INVOICE VIEW for items with a quoted prices that exceed $$100.$

Task $6$: Repeat Task $5$ without using the ITEM$\_$INVOICE VIEW to retrieve the item ID$,$ description, price, invoice number, invoice date, quantity, and quoted price for all items with a quoted price that exceed $$100.$

Task $7$: Create a view named INVOICE$\_$TOTAL. It consists of the invoice number and invoice total for each invoice currently on file. $($The invoice total is the sum of the number of units ordered multiplied by the quoted price on each invoice line for each invoice.$)$ Sort the rows by invoice number. Use TOTAL$\_$AMOUNT as the name for the invoice total.