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