In this module, your focus is on SQL syntax. As in each related activity, questions are from the Colonial Adventure Tours Case. It's time to create a SQL Server query for a response (not the actual data that is returned). Please make sure you carefully evaluate the syntax, as even the most minor typo will cause a query to fail. For this assignment, address the following: 1. List the name of each trip that does not start in Vermont [VT]. 2. List the name and start location for each trip that has the type Hiking. 3. List the name of each trip that has the type Hiking and that has a distance of greater than four miles. 4. List the name of each trip that has the type Paddling or that is located in Connecticut [CT). 5. How many trips have a type of Hiking or Biking? 6. List the name of each trip that has the type Hiking and that is guided by Rita Boyers. 7. How many trips originate in each state? 8. How many reservations include a trip with a price that is greater than $20 but less than $75? 9. List the reservation ID, customer number