Task $1$: List the item ID as ITEM$\_$ID and description as ITEM$\_$DESC for all items. The descriptions should appear in uppercase letters.

Task $2$: List the customer ID and first and last names for all customers located in the city of Cody. Your query should ignore case. For example, a customer with the city Cody should be included, as should customers whose city is CODY, cody, cOdY, and so on$.$

Task $3$: List the customer ID$,$ first and last names, and balance for all customers. The balance should be rounded to the nearest dollar.

Task $4$: KimTay Pet Supplies is running a promotion that is valid for up to $20$ days after an order is placed. List the INVOICE$\_$NUM, CUST$\_$ID$,$ FIRST$\_$NAME, LAST$\_$NAME, INVOICE$\_$DATE, and the promotion date for each invoice as PROMOTION$\_$DATE. The promotion date is $20$ days after the INVOICE$\_$DATE was placed.

Use the DATE$\_$ADD function to add a date interval to the invoice date that uses the following syntax: DATEADD$(\_$date, INTERVAL value DAY$)$

Task $5$: Create the GET$\_$CREDIT$\_$LIMIT procedure to obtain the full name and credit limit of the customer whose ID currently is stored in I$\_$CUST$\_$ID$.$ Place these values in the variables I$\_$CUSTOMER$\_$NAME and I$\_$CREDIT$\_$LIMIT, respectively. When the procedure is called it should output the contents of I$\_$CUSTOMER$\_$NAME and I$\_$CREDIT$\_$LIMIT.

Task $6$: Create the GET$\_$INVOICE$\_$DATE procedure to obtain the customer ID$,$ first and last names of the customer, and the invoice date for the invoice whose number currently is stored in I$\_$INVOICE$\_$NUM. Place these values in the variables I$\_$CUST$\_$ID$,$ I$\_$CUST$\_$NAME, and I$\_$INVOICE$\_$DATE respectively. When the procedure is called it should output the contents of I$\_$CUST$\_$ID$,$ I$\_$CUST$\_$NAME, and I$\_$INVOICE$\_$DATE.

Task $7$: Create the ADD$\_$INVOICE procedure to add rows to the INVOICE table.

Task $8$: Create the UPDATE$\_$INVOICE procedure to change the date of the invoice whose number is stored in I$\_$INVOICE$\_$NUM to the date currently found in I$\_$INVOICE$\_$DATE.

Task $9$: Create the DELETE$\_$INVOICE procedure to delete the invoice whose number is stored in I$\_$INVOICE$\_$NUM.

Task $10$: Create the ADD$\_$COMMISSION$\_$TRIG trigger to add the customer$$s balance multiplied by the sales rep$$s commission rate to the commission for the corresponding sales rep when adding a new customer.

Task $11$: Create the UPD$\_$COMMISSION$\_$TRIG trigger to add the difference between the new balance and the old balance multiplied by the sales rep$$s commission rate to the commission for the corresponding sales rep when updating a customer.

Task $12$: Create the DEL$\_$COMMISSION$\_$TRIG trigger to subtract the balance multiplied by the sales rep$$s commission rate from the commission for the corresponding sales rep when deleting a customer.