Question: 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

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 CITY QUIDEM LATIME FREADORES AN APOTIL.CODE POENOMMERCE 4. CUSTOMER1 CUSOMEAM LAST JMMEDORES OTY FOTO ROE E PURE IPON D SEN DE TEL IND HT WW M HA HVETE W PO HINGEN TEM HE 15.01 SO TRP THU 6 TH NAME START LOCATION SEASON VIE SB La 101 PIE LE 1 STATE DISTANCE MAX.GPO SOE TYPE SII ST 13 VT 6 SK 23 ME ME CT 30 Med SII SI Ech RESERVATION RESERVATION.D TRP.0 TROP_DICE NUMU PERSONS TREPRICE OTHERS CUSTOMER 2016 3 10 2 1 D. + SE360 SIS 16 5 558.00 Sobo INDUS 1 23 16 5 ST BIS 18 W123- 500 100RON 38w S 1000 2 USUS IE IN CAN BICNEOLINE DS Sony La w S ES Sale Tab TRIP GUIDES TRIP_ID GUIDE_NUM LCD 1
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
