Task $1$: Create a VIEW named MAJOR$\_$CUSTOMER. It consists of the customer ID$,$ first name, last name, balance, credit limit$,$ and rep ID for every customer whose credit limit is $$500$ or less.

Task $2$: Write and execute the command to retrieve the customer ID$,$ first name, and last name of each customer in the MAJOR$\_$CUSTOMER VIEW with a balance that exceeds the credit limit$.$

Task $3$: Without using the MAJOR$\_$CUSTOMER VIEW, retrieve the customer ID$,$ first name, and last name for every customer whose credit limit is $$500$ or less.

Task $4$: Create a VIEW named ITEM$\_$INVOICE. It consists of the item ID$,$ description, price, invoice number, invoice date, quantity, and quoted price for all invoice lines currently on file.

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. From The Textbook, A Guide to SQL$,10$th edition