Database systems
Colonial adventure tours
Use SQL and the Colonial Adventure Tours data base to completethe following exercises.
1. For each reservation, list the reservation ID, trip ID,customer number, and customer last name. Order the results bycustomer last name.
2. For each reservation for customer Ryan Goff, list thereservation ID, trip ID< and number of persons.
3. List the trip name of each trip that has Miles Abrams as aguide.
4. List the trip name of each trip that has the type Biking andthat has Rita Boyers as a guide.
5. For each reservation that has a trip date of July 23, 2016,list the customer’s last name,
OR
OR