Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

CUSTOMER table INVOICE TABLE LINE TABLE PRODUCT TABLE VENDOR TABLE Using MySql Workbench only, provide the full code necessary to Find the listing of all

image text in transcribedimage text in transcribedCUSTOMER tableimage text in transcribedINVOICE TABLEimage text in transcribedLINE TABLEimage text in transcribedPRODUCT TABLEimage text in transcribedVENDOR TABLE

Using MySql Workbench only, provide the full code necessary to Find the listing of all customers who purchased 6 or more line_units. Your output must match the output shown below CUS_CODE SUM_LINE_UNITS 10011 16 10012 7 10014 8 10018 12 CUS_CODE CUS_LNAME CUS_FNAME CUS_INITIAL CUS_AREACODE CUS_PHONE CUS_BALANCE 10010 Ramas Alfred 615 844-2573 $0.00 10011 Dunno Loona K 713 804-1238 $0.00 10412 Smith Kathy WV 615 844-2285 $345.86 10013 Olowski Paul F 615 894-2180 $536.75 10011 Orlando Myron 615 222 1672 $0.00 100:15 O'Brian Amy B 713 442-3381 $0.00 10016 Brown James 615 297-1228 $221.19 10017 Williams George 615 290-2556 $768.93 10018 Farriss Alle 713 382-7185 $216.55 10019 Smith Olette K 615 297-3809 $0.00 INV_NUMBER CUS_CODE INV_DATE 1001 10014 Wednesday, August 18, 1999 1002 10011 Wednesday, August 18, 1999 1003 10012 Wednesday, August 18, 1999 1004 10011 Thursday, August 19, 1999 1005 10018 Thursday, August 19, 1999 1006 10014 Thursday, August 19, 1999 1007 10015 Thursday, August 19, 1999 1008 10011 Thursday, August 19, 1999 INV_NUMBER LINE_NUMBER P_CODE LINE_UNITS 1001 1 13-Q2/P2 1 1001 2 23109-HB 1 1002 1 54778-2T 2 1003 1 2238/QPD 1 1003 2 1546-QQ2 1 1003 3 13-Q2/P2 5 1004 1 54778-2T 3 1004 2 23109-HB 2 1005 1 PVC23DRT 12 1006 1 SM-18277 1006 2 2232/QTY 1 1006 3 23109-HB 1 1006 4 89-WVRE-Q 1 1007 1 13-02/P2 2 1007 2 54778-2T 1 1008 1 PVC23DRT 5 1008 2 WR3/TT3 3 1008 3 23109-HB 1 LINE_PRICE $14.99 $9.95 $4.99 $38.95 $39.95 $14.99 $4.99 $9.95 $5.87 $6.99 $109.92 $9.95 $256.99 $14.99 $4.99 $5.87 $119.95 $9.95 P CODE P DESCRIPT 11QER/31 Power painter, 15 psi., 3-nozzle 13-02/P2 7.25-in. pwr. saw blade 14-Q1/L3 9.00-in. pwr. saw blade 1546-Q02 Hrd. cloth, 1/4-in., 2x50 1558-QW1 Hrd. cloth, 1/2-in., 3x50 2232/QTY B&D jigsaw, 12-in, blade 2232/QWE B&D jigsaw, 8-in. blade 2238/QPD B&D cordless drill, 1/2-in. 23109-HB Claw hammer 23114-AA Sledge hammer, 12 lb. 54778-2T Rat-tail file, 1/8-in, fine 89-WRE-Q Hicut chain saw, 16 in. PVC23DRT PVC pipe, 3.5-in., 8-ft SM-18277 1.25-in. metal screw, 25 SW-23116 2.5-in. wd. screw, 50 WR3/TT3 Steel matting, 4x8X1/6"..5" mesh PINDATE P ONHANDP MIN P PRICEP DISCOUNT V CODE 03-Nov-01 8 5 $109.99 0.00 25595 13-Dec-01 32 15 $14.99 0.05 21344 13-Nov-01 18 12 $17.49 0.00 21344 15-Jan-02 15 $39.95 0.00 23119 15-Jan-02 23 $43.99 0.00 23119 30-Dec-01 8 $109.92 0.05 24288 24-Dec-01 6 $99.87 0.05 24288 20-Jan-02 12 $38.95 0.05 25595 20-Jan-02 23 10 $9.95 0.10 21225 02-Jan-02 8 $14.40 0.05 15-Dec-01 43 20 $4.99 0.00 21344 07-Feb-02 11 5 $256.99 0.05 24288 20-Feb-02 188 15 $5.87 0.00 01-Mar-02 172 75 $6.99 0.00 21225 24-Feb-02 237 100 $8.45 0.00 21231 17-Jan-02 18 5 $119.95 0.10 25595 5 E285555gsmsws V_CODE V_NAME V_CONTACT 21225 Bryson, Inc. Smithson 21226 SuperLoo, Inc. Flushing 21231 D&E Supply Singh 21344 Gomez Bros. Ortega 22567 Dome Supply Smith 23119 Randsets Ltd. Anderson 24004 Brackman Bros. Browning 24288 ORDVA, Inc. Hakford 25443 B&K, Inc. Smith 25501 Damal Supplies Smythe 25595 Rubicon Sis. Orton V_AREACODE 615 904 615 615 901 901 615 615 904 615 904 V_PHONE 223-3234 215-8995 228-3245 889-2546 678-1419 678-3998 228-1410 898-1234 227-0093 890-3529 456-0092 V_STATE V_ORDER TN Y FL N TN Y KY N GA N GA Y TN N TN Y FL N TN N FL Y

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_2

Step: 3

blur-text-image_3

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

MySQL/PHP Database Applications

Authors: Brad Bulger, Jay Greenspan, David Wall

2nd Edition

0764549634, 9780764549632

More Books

Students also viewed these Databases questions

Question

4. What actions should Bouleau & Huntley take now?

Answered: 1 week ago