QL DATABASE need the SQL statements FROM ATTACHED tables List the trip name of each trip that has Miles Abrams as a guide. 2. For each reservation that has a trip date of July 23, 2016, list the customer’s last name, the trip name, and the start location. 3. List the reservation ID, trip ID, and trip date for reservations for a trip in Maine (ME). Use the IN operator in your query.
SQL
need the SQL statements FROM ATTACHED tables
- List the trip name of each trip that has Miles Abrams as a guide.
2. For each reservation that has a trip date of July 23, 2016, list the customer’s last name, the trip name, and the start location.
3. List the reservation ID, trip ID, and trip date for reservations for a trip in Maine (ME). Use the IN operator in your query.
4. Repeat Exercise 3, but this time use the EXISTS operator in your query.
5. Find the guide last name and guide first name of all guides who can lead a paddling trip
6. Repeat Exercise 5 but use aliases for the table names.
7. Find the trip name of all reservations for hiking trips and sort the results by trip name in ascending order.
8. List the number and name of each customer that lives in the state of New Jersey (NJ) and that currently has a reservation.
9. Find the trip ID and trip name for each trip whose maximum group size is greater than the maximum group size of at least one trip that has the type Biking.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps