Using SQL complete the following questions 1-4

Colonial Adventure Tours Use the Colonial Adventure Tours database (see Figures 1-4 through 1-8 in complete the following exercises. If directed t provided with the Chapter 3 Exercises to print your output or save it to a o do so by your instructor, use the information the guide number, first name, and last name for all guides. The first name should r in lowercase letters and the last name should appear in uppercase letters. 1. List appea 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. 2. List the reservation ID, trip date, and price for all trips. The price should be rounded to the nearest dollar. 4. Write PL/SQL 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 LGUIDE_NUM. Place these values in the variables LFIRST_NAME and ILAST_NAME. Output the contents of I_GUIDE NUM, L FIRST_NAME, and LAST_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 l NUM PERSONS, LCUSTOMER NUM, and I LAST_NAME, respectively. Output the contents of INUM PERSONS, L CUSTOMER NUM, and 1 LAST NAME. a. b. c. Add a row to the GUIDE table. d. Change the last name of the guide whose number is stored in I_GUIDE NUM to the value currently found in I LAST_NAME. e. Delete the guide whose number is stored in I_GUIDE NUM