Task $1$: List the owner number, the owner's first name as FIRST and the owner's last name as LAST for all owners. The first name should appear in uppercase letters and the last name should appear in lowercase letters.

Task $2$: List the owner number and last name for all owners located in the city of Seattle. Your query should ignore case. For example, a customer with the city Seattle should be included, as should customers whose city is SEATTLE, SEAttle, SeAttle, and so on$.$

Task $3$: StayWell is offering a monthly discount for residents who pay their rent on a quarterly basis. The discount is $1\mathrm{.}75$ percent of the monthly fee. For each property, list the office number, address, owner number, owner$$s last name, monthly rent, and discount as DISCOUNT. The discount should be rounded to the nearest dollar.

Task $4$: Create the DISPLAY$\_$OWNER procedure which obtains the first name and last name of the owner whose number currently is stored in I$\_$OWNER$\_$NUM $($provided as a parameter$).$ Place these values in the variables I$\_$FIRST$\_$NAME and I$\_$LAST$\_$NAME. Output the contents of I$\_$OWNER$\_$NUM, I$\_$FIRST$\_$NAME, and I$\_$LAST$\_$NAME.

Task $5$: Create the DISPLAY$\_$PROPERTY$\_$OWNER procedure which obtains the office location number, address, owner number, owner first name, and owner last name for the property whose property ID is currently stored in I$\_$PROPERTY$\_$ID $($provided as a parameter$).$

Place these values in the variables I$\_$LOCATION$\_$NUM, I$\_$ADDRESS, I$\_$OWNER$\_$NUM, I$\_$FIRST$\_$NAME, and I$\_$LAST$\_$NAME, respectively. Output the contents of I$\_$LOCATION$\_$NUM, I$\_$ADDRESS, I$\_$OWNER$\_$NUM, I$\_$FIRST$\_$NAME, and I$\_$LAST$\_$NAME.

Task $6$: Add the following record to the OWNER table:

INSERT INTO OWNER VALUES$(\text{'}$SA$100\text{'},$ 'Sam', 'Afyouni', $\text{'}100$ Hello St$\text{'},$ 'Anytown', $\text{'}$MA$\text{'},\text{'}55555\text{'})$;

Task $7$: Create the UPD$\_$OWNER$\_$LAST$\_$NAMEprocedure to change the last name of the owner whose number is stored in I$\_$OWNER$\_$NUM $($provided as a parameter$)$ to the value currently found in I$\_$LAST$\_$NAME.

Task $8$: Create the DEL$\_$OWNER procedure to delete the owner whose number is stored in I$\_$OWNER$\_$NUM $($provided as a parameter$).$

Task $9$: Create the DISP$\_$PROPERTYS procedure to retrieve and output the office number, address, monthly rent, and owner number for every property whose square footage is equal to the square footage stored in I$\_$SQR$\_$FT $($provided as a parameter$).$

Store these values in I$\_$LOCATION$\_$NUM, I$\_$ADDRESS, I$\_$MONTHLY$\_$RENT, and I$\_$OWNER$\_$NUM and display them when the procedure is called. From the textbook, A Guide to SQL $10$th Edition $($hope you can read the lists in the photo$)$