1. List the guide number, first name, and last name for all guides. The first na
ID: 3719114 • Letter: 1
Question
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.Explanation / Answer
Q1) SELECT GUIDE_NO, LOWER(FIRST_NAME), UPPER(LAST_NAME) FROM GUIDES;
Q2) SELECT TRIP_ID, TRIP_NAME FROM TRIPS WHERE LOWER(TRIP_NAME) = 'bar harbour');
Q3) SELECT RESERVATION_ID, TRIP_DATE, ROUND(TRIP_COST, 2) AS 'TOTAL_TRIP_COST' FROM TRIPS;
Please let me know in case of any clarifications required. Thanks!
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.