Use SQL and Colonial Adventure Tour database to complete the following Exercises

SQL Functions and Procedures total number of persons for that the s in PL/SQL or T-SQL for the following triggers: e contains a column named TOTAL PERSONS that represents the t trip. Following the style shown in the text, write the code the TOTAL PERSONS value for the appropriate trip ng a row in the RESERVATION table, add the NUM PERSONS value to b. Wh en updating a row in the RESERVATION table, add the difference between the new NUM PERSONS value and the old NUM PERSONS value TOTAL_P to the ERSONS value for the appropriate trip. deleting a row in the RESERVATION table, subtract the NUM PERSONS c. When value from the TOTAL PERSONS value for the appropriate trip. 9. Because the TRIP table contains several columns with character data, the staff at Colo- nial Adventure Tours would like to know more about string or character functions. Use the Internet to research the following string functions: LENGTH, SUBSTR, and INITCAP. Are these functions the same in Oracle, SQL Server, and Access? Write a paragraph that discusses what the functions do and any differences and/or similarities between the func- tions in Oracle, SQL Server, and Access. Then perform the following tasks using Oracle SQL: a. Display the first three characters on the left from the TYPE column. b. Starting at the fourth character from the left, display the next five characters in the START LOCATION column