Answer each of the following questions using the Colonial Adventure Tours data shown in Figures 1-15 through 1-19. No computer work is required.
1. List the last name of each guide that does not live in New Hampshire (NH).

2. List the trip name of each trip that has the type Paddling.
3. List the trip name of each trip that has the season Late Spring.
4. List the trip name of each trip that has the type Biking and that has a distance longer than 20 miles.
5. List the trip name of each trip that is in the state of Vermont (VT) or that has a maximum group size greater than 15.
6. List the trip name of each trip that has the season Early Fall or Late Fall.
7. How many trips are in the states of Vermont (VT) or Connecticut (CT)?
8. List the trip name of each trip that has Miles Abrams as a guide.
9. List the trip name of each trip that has the type Biking and that has Rita Boyers as a guide.
10. 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.
11. How many reservations have a trip price that is greater than $50.00 but less than $100.00?
12. For each trip that has more than one guide that can lead the trip, list the trip name, the trip type, and the first and last names of each guide.
13. For each customer that has more than one reservation, list the customer€™s first and last names, the trip name, and the trip type.
14. For each reservation with a trip price of greater than $100.00, list the customer€™s last name, the trip name, and the trip type.
15. List the last name of each customer who has a reservation for a trip in Maine (ME).
16. The trip price in the Reservation table is a per-person price. The total price for a trip includes the total of the trip price and the other fees multiplied by the number of people taking the trip. Should total price be a field in the Reservation table? Why or why not?
17. Currently, trip cost is determined by the number of people taking the trip and the type of trip. If trip cost were based only on the type of trip, in which table would you place the trip cost field?

Figure 1-15

GuideNum LastName FirstName Address State PostalCode PhoneNum HireDate City Miles 54 Quest Ave. 140 Oakton Rd. 25 Old Ranch Rd. Sunderland 7 Moose Head Rd. Dummer 943 Oakton Rd. 9 Congaree Ave. 24 Shenandoah Rd. Springfield 12 Heather Rd. 15 Riverton Rd. 617-555-6032 AM01 6/3/2012 3/4/2012 Williamsburg MA 01096 Jaffrey Abrams BR01 NH 03452 603-555-2134 Boyers Rita DH01 Harley 781-555-7767 01375 1/8/2012 Devon MA GZ01 Gregory Zach 03588 603-555-8765 11/4/2012 4/8/2013 NH Kiley Susan Jaffrey Fraconia KS01 03452 NH 603-555-1230 KS02 603-555-0003 6/10/2013 03580 Sam Ray Hal NH Kelly Marston Rowan MR01 MA 01101 Mount Desert ME 781-555-2323 9/14/2015 RH01 207-555-9009 04660 6/2/2014 Stevens 802-555-3339 SL01 05825 9/5/2014 2/2/2015 Lori Coventry VT Unser 342 Pineview St. UG01 06810 203-555-8534 Glory Danbury CT