1. List the guide number, first name, and last name for all guides. The first name should appear in lowercase letters and the last name should appear in uppercase letters. 2. List the trip ID and trip name for all trips that start in Bar Harbor. Your query should ignore case. For example, a trip with the start location of Bar Harbor should be included as should trips whose start location is BAR HARBOR, Bar harbor, BaR HarBor, and so on. 3. List the reservation ID, trip date, and price for all trips. The price should be rounded to the nearest dollar 4. Write PLISQL or T-SQL procedures to accomplish the following tasks: Obtain the first name and last name, separated by a space, of the guide whose number currently is stored in I_GUIDE_NUM. Place these values in the variables I_FIRST_NAME and I LAST_NAME. Output the contents of ILGUIDE_NUM, I_FIRST_NAME, and LLAST_NAME. Obtain the number of persons, customer number, and customer last name for every reservation whose ID currently is stored in LRESERVATION ID. Place these values in the variables _ NUM_PERSONS, I_CUSTOMER NUM, and I _LAST_NAME, respectively Output the contents of I NUM PERSONS, LCUSTOMER_NUM, and I_LAST_NAME. Add a row to the GUIDE table. a. b. c. d. Change the last name of the guide whose number is stored in I_GUIDE_NUM to the e. Delete the guide whose number is stored in I_GUIDE_NUM. number of persons, and trip price for every reservation whose customer number is stored value currently found in I_LAST_NAME. 5. Write PLISQL or T-SQL procedures to retrieve and output the reservation ID, trip ID in I CUSTOMER NUM