Database Systems Colonial Adventure Tours Use Sql Colonial Adventure Tours Data Base Compl Q37228207

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

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.