Part 2 - Short Answer, 40%

Use the table sheets (TAL Distributors and/or Colonial Adventure Tours) to complete questions 1 to 4.

Each answer for each question, 1 to 4, must diplay a table format (columns and rows), which must include:

1. column names;
2. row data.

1. For each reservation, list the customer number, last name, and first name of each customer who has a trip price that is greater than $20.00 and less than $50.00. (5%)

1. Use the attached Colonial Adventure table sheet.
2. Display results, which must include column names and row data.

Colonial Adventure GUIDE GUIDE_NUM LAST_NAME FIRST_NAME ADDRESS CITY STATE POSTAL_CODE PHONE_NUM HIRE_DATE AM01 Abrams Miles 01096 617-555-6032 1/3/2012 54 Quest Ave. 140 Oakton Rd. Rita Williamsburg MA Jaffrey NH Sunderland MA 03452 603-555-2134 BRO1 DH01 34/2012 25 Old Ranch Rd. 01375 781-555-7767 1/2012 Boyers Devon Gregory Kiley Harley Zach GZ01 0358s 603-555-8765 11/4/2012 KS01 Susan 03452 603-555-12.30 4/8/2013 CUSTOMER1 CUSTOMER_NUM LAST_NAME FIRST_NAME ADDRESS CITY STATE POSTAL_CODE PHONE 101 Northfold Liam 9 Old Mill Rd. Londonderry NI 03053 603-555-7563 102 Ocean Arnold (2332 South St. Apt 3 Springfield MA 01101 413-555-3212 103 Kasuma Sujata 132 Main St. #1 East Hartford CT 06105 860-555-0703 104 Goff Ryan 164A South Bend Rd. Lowell MA 01854 781-555-8423 105 McLean Kyle 345 Lower Ave Wolcott NY 14590 555-555-5321 106 Morontoia Joseph 156 Scholar St. Johnston RI 02919 401-555-4848 107 Marchand Quinn 76 Cross Rd. Bath NH 03740 603-555-0456 105 Ruli Usclui 32 Sheep Stop St. Edinboro PA 16412 814-555-5521 109 | Caron Jean Lue 10 Greenfield St. Rome ME 04963 207-555-9643 110 Bers Martha 65 Granite St. York INY 14592 585-555-0111 RESERVATION KS02 Kelly 7 Moose Head Ra. Dummer NH 943 Oakton Rd. Jaffrey NH 9 Congarve Ave. Fraconia NH 24 Shenandoah Rd. Springfield MA 12 Heather Ra Mount Desert NE Samn 03550 MR01 Marston Tele 01101 603-555-0003 751-555-2323 207-555-9009 802.555-3339 Ray Hal RH01 Rowan 04660 6/10/2013 9/1-4/2015 6/2/2014 9/5/2014 2/2/2015 SL01 Stevens Lori 15 Riverton Rd. VT 05825 Coventry Danbury UG01 Unser Glory 342 Pineview St. CT 06810 203-555-8534 TRIP TRIP_ID TRIP_NAME 1 Arethusa Falls 2 Mt Ascutney - North Peak 3 Mt Ascutney - West Peak 4 Bradbury Mountain Ride 5 Baldpate Mountain 6 Blueberry Mountain 7 Bloomfield - Maidstone Black Pond 9 Big Rock Cave 10 Mt. Cardigan - Firescrew TRIP_GUIDES START_LOCATION Harts Location Weathersfield Weathersfield Lewiston-Auburn North Newry Batchelders Grant Bloomfield Lincoln Tamworth Orange STATE DISTANCE MAX_GRP SIZE TYPE SEASON NII 10 Hiking Summer VT 5 Hiking Late Spring VT 6 10 lliking Early Fall 25 & Biking Early Fall ME 6 10 Hiking Late Spring ME 8 Hiking Early Fall 10 6 Paddling Late Spring NHI S 12 Hiking Summer NII 6 10 Hiking Summer NH 7 8 Hiking Summer RESERVATION_ID TRIP_ID TRIP_DATE NUM_PERSONS TRIP_PRICE OTHER_FEES CUSTOMER_NUM 1600001 40 3/26/2016 2 $55.00 $0.00 101 1600002 21 6/8/2016 2 $95.00 $0.00 101 1600003 28 9/12/2016 1 $35.00 $0.00 103 1600004 26 10/16/2016 4 $15.00 $15.00 104 1600005 39 6/25/2016 5 $55.00 $0.00 | 105 1600006 32 (J18/2016 1 $80.00 $20.00 | 106 1600007 22 7/9/2016 8 $75.00 $10.00 107 1600008 28 9/12/2016 2 $35.00 $0.00 108 1600009 38 9/11/2016 2 $90.00 $40.00 109 1600010 25/14/2016 3 $25.00 $0.00 | 102 TRIPID 1 1 GUIDE_NUM GZ01 RH01 AMOT SL01