Need help with these SQL commands if someone could help me ASAP i\'ll gretly app

Question

Need help with these SQL commands if someone could help me ASAP i'll gretly appreciate it

Colonial Adventure Tours Use SQL and the Colonial Adventure Tours database (see Ch. 1 in your text) to complete the following exercises. Provide downloads of guery outputs For each reservation, list the reservation ID, trip ID, customer number, and customer last name. Order the results by customer last name. For each reservation for customer Ryan Goff, list the reservation ID, trip ID, and number of persons. List the trip name of each trip that has Miles Abrams as a guide. List the trip name of each trip that has the type Biking and that has Rita Boyers as a guide. 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. List the reservation ID, trip ID, and trip date for reservations for a trip in Maine (ME). Use the IN operator in your query. 1. 2. 3. 4. 5. 6.

Explanation / Answer

Solution:

Note: The schema is not provided, so I am providing the queries on the general assumption, please adjust accordingly.

Note: The first four subparts have been answered as per Chegg guidelines, please repost others.

1)

SELECT reservation_ID, trip_ID, customer_number, last_name, from Reservation ORDER BY last_name.

2)

SELECT reservation_ID, trip_ID, COUNT(customer_number) from Reservation WHERE last_name= 'Goff' AND first_name = 'Ryan'

3)

SELECT trip_name FROM Trip INNER JOIN Trip_Guides ON Trip.guide_number = Trip_Guides .guide_number WHERE guide_name = 'Miles Abrams'

4)

SELECT trip_name FROM Trip INNER JOIN Trip_Guides ON Trip.guide_number = Trip_Guides .guide_number WHERE guide_name = 'Rita Boyes' AND type = 'Biking'

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.