Question 1 to 5 (first pic); Question 18 (second pic); Question 7 and 10 (third pic); Question 15 (last pic)

Colonial Adventure Tours Use SQL and the Colonial Adventure Tours database (Fiaures 1-4 through 1-8 in Chapter 1) to complete the following exercises. If directed to do so by your instructor, use the information provided with the Chapter 3 Exercises to print your output or save it to a document. 1. List the last name of each guide that does not live in Massachusetts (MA). 2. List the trip name of each trip that has the type Biking. 3. List the trip name of each trip that has the season Summer. 4. List the trip name of each trip that has the type Hiking and that has a distance longer than 10 miles. 5. List the customer number, customer last name, and customer first name of each customer that lives in New Jersey (NJ), New York (NY) or Pennsylvania (PA). Use the IN operator in your command. 6. Repeat Exercise 5 and sort the records by state in descending order and then by cus- tomer last name in ascending order 7. How many trips are in the states of Maine (ME) or Massachusetts (MA)