Week2 - 1 List the number and name of all customers 148 Als...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
1. List the number and name of all customers. 148, Al’s Appliance and Sport 282, Brookings Direct 356, Ferguson’s 408, The Everything Shop 462, Bargains Galore 524, Kline’s 608, Johnson’s Department Store 687, Lee’s Sport and Appliance 725, Deerfield’s Four Seasons 842, All Season 2. List the complete Part table. AT94 Iron 50 HW 3 $24.95 BV06 Home Gym 45 SG 2 $794.95 CD52 Microwave Oven 32 AP 1 $165.00 DL71 Cordless Drill 21 HW 3 $129.95 DR93 Gas Range 8 AP 2 $495.00 DW11 Washer 12 AP 3 $399.99 FD21 Stand Mixer 22 HW 3 $159.95 KL62 Dryer 12 AP 1 $349.95 KT03 Dishwasher 8 AP 3 $595.00 KV29 Treadmill 9 SG 2 $1,390.00 3. List the number and name of all customers represented by sales rep 35. 282, Brookings Direct; 408, The Everything Shop; 687, Lee’s Sport and Appliance; 725, Deerfield’s Four Seasons 4. List the number and name of all customers that are represented by sales rep 35 and that have a credit limit of $10,000. 282, Brookings Direct
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 2

Week2 - 1 List the number and name of all customers 148 Als...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online