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