List the trip name, type, and maximum group size for all trips that have Sam Kelly as a guide. SELECT TripName, Type, MaxGrpSize FROM Trip, Guide, WHERE Trip. AND Guide.GuideNum = AND LastName = 'Kelly'; List the reservation ID, customer last name, and the trip name for all reservations where the number of persons included in the reservation is greater than four. SELECT ReservationID, LastName, TripName FROM Reservation, Trip, WHERE TriplD = Trip. TriplD AND Reservation.CustomerNum = AND Answer 1: Customer Colonial Adventure Tours calculates the total price of a trip by adding the trip price plus other fees and multiplying the result by the number of persons included in the reservation. List the reservation ID, trip name, customer's last name, and total cost for all reservations where the number of persons is greater than four. Use the column name TotalCost for the calculated field. SELECT ReservationID, TripName, LastName, ((TripPrice + OtherFees) NumPersons) FROM , Trip, Customer WHERE Reservation. TripID = Trip. TriplD AND Reservation.CustomerNum = AND NumPersons > 4; Add a new reservation to the Reservation table for reservation ID of 1600031 , trip ID of 12 , trip date of 10/1/2016, number of persons of 2 , trip price of $40, other fees of $11, customer number of 123 . INSERTINTO VALUES 12, ,2,40 123); Colonial Adventure Tours Guide Reservation Trin