Developing of Databases
For this homework use the Colonial Adventure Tours database. Copy-Paste the SQL queries and the results below each exercise.
1. For each reservation, list the reservation ID, trip ID, customer number, and customer last name. Order the results by customer last name.
2. List the trip name of each trip that has the type Biking and that has Rita Boyers as a guide.
3. Find the guide last name and guide first name of all guides who can lead a paddling trip.
(Note: The query results should include the duplicate values.)
4. List the number and name of each customer that either lives in the state of New Jersey (NY), or that currently has a reservation, or both.
5. Display the trip ID, trip name, and reservation ID for all trips. All trips should be included in the result. For those trips that currently do not have reservations, the reservation ID should be left blank. Order the results by trip ID.
6. Repeat question 3 but list the guide name only once and sort the guide names in order by last name.