Tours SQL 1B Colonial Adventure Tours Case:

FIRST test each query in Access or Base and the code you submit must run without any error.

Copy and paste tested SQL code under each question.

1. List the name and start location of each trip of the Hiking type. 2. List the name and state of each trip that starts in NH or VT. 3. List the name and state of each trip that does not start in ME or MA. 4. List the name of each trip that has the type Hiking or that in the early fall season. 5. List the name and distance for each Paddling trip with a distance greater than 10 miles. 6. List the trip name, state, and distance of each late spring or summer season Paddling type trip in NH or ME. Order by state, then distance. 7. List reservation ID, customer number, and trip date of each trip reservation for August of 2018. 8. List reservation ID, customer last name, customer first name, and trip date for each trip reservation for October of 2018. 9. List the name, type and distance of each trip that has the type Biking or Paddling and that has a distance greater than 8 miles. Order by type, then distance. 10. List reservation ID, customer last name, customer first name, and trip date for each trip reservation for September or October of 2018.