Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
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. ORDERED REP REP NUM LAST NAME FIRST NAME STREET CITY STATE POSTAL COOK COMMSSON RATE 15 CA $35.457.000 . C. ALS CA HIJITON ES 175 TV No CA 1133 1370 SOCA 90.000 RE CUSTOMER DATOMER CAM CITY CODE LANGE CHELTENIM CA TO Thr LIVENOL ORDER LINE ORDER NUM TEMMUM NUM ORDERED QUOTED PENCE 510 51610 KLIN SIS 51610 THO 3 SI DESI 51614 DI 1 N1617 NEN + 3115. S1617 TW3 3 311695 51019 VOIL 51623 DRT 5 51623 F1124 12 51623 KEN 10 51625 MITOS Meme A Now MACA CA STO 471 S. $123 NICA STOREHOUSE PRICE 1 che ITEM ITEM NUM A1174 BR23 CD33 DL51 DRO7 DW23 FD11 F1124 KA12 3 DESCRIPTION Patience Skittles Wood Block Set (48 piece) Classic Railway Set Giant Star Brain Teaser Manoul Rooking Horse Puzzle Gift Set Cribbage Sur ON_HAND CATEGORY 9 CME 2I|SE 36 TOY 12 TOY 24 PZL 40|GAME TOY 65PZL 56 | OME 5.29.99 $$9.49 $107.95 $31.95 $50.00 $124.95 $3.95 $75.00 3 1 3 UNDEN CITTC CUSTOMER COMER MATRET CITY STATE POSTAL BALANCEOL LATINA ORDER NUM ITEM NUM 31 NUM ORDERED QUOTED PRICE th GA Din ana The thing $16.10 CA 1,5 10.05 TH40 16 51 Husi 5 51614 40 CA 81617 NINO + S11 S1617 Twas S116 CA S1619 FD11 512105 A. AGA SIS S1603 DRAT 33 1134 DEE CA LEGA 343 S16201 KU 10 TMC 512173 OBS 5112 MTO 5457 ITEM ITEM NUM DESCRIPTION ON HAND CATEGORY STOREHOUSE PRICE AH74 Patience CME BR23 Skittles 21 GIE 2 $29.97 CD33 Wood Block Set (48 piece) 36 TOY 1 SN9:49 DLS1 Classic Railway Set 12 TOY $107.95 DR67 Giant Star Brain Teaser 24 PZL $31.95 DW23 Mancata 40 | GMIE $50.00 FDI Rocking Horse STOY $124.95 FH124 Puzzle Gift Set 1 65PZL $.38,95 KA12 3 56 CME Cribbage Set $75.00 KD34 Pentomincies Brain Teaser 60 PZL 2 $14.95

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeffrey A. Hoffer Fred R. McFadden

4th Edition

0805360476, 978-0805360479

More Books

Students also viewed these Databases questions