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 I_GUIDE_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