Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
1- Generate a listing of all purchases made by the customers, using the output shown below as your guide. Sort the results by customer code, invoice number, and product description. Cus CODE INV_NUMDEN INV DATE LNE UNITS LINE ICE 1002 16-Jon-18 Rat-tal file, 10-n. fine 1004 17-Jam-10 Claw haTmer 10011 4,99 10011 9.95 10011 1004 17-Jan-18 Ret-tal fle, 1.8-n. fine 3 439 10011 1003 17-Jan-16 Claw harmer 9.95 10011 1009 17-lan-18 PVC pipe, 3.Sin 8-tt in 597 10011 1009 17-Jan-18 Sleel mettinga, 4x8'x1.6", .5" mesh 119.95 10012 1003 16-lan-187 25-n. pw. saw blode 1003 16-Jan-18 B8D cordless ril, 1/2in. 1003 18-lam-10 Hrd deth, 14in., 2x50 14.99 10012 38.95 10012 99.95 10014 1001 16-Jan-18 725-n. pwr. saw blede 14.99 10014 1001 16-lan-18 Claw harmer 995 1003 17-Jan-10 1 25-n. melel screw, 25 17-lan-18 BBD jasaw, 124n. lalade 10014 6.99 10014 100 109.92 10014 1005 17-Jan-18 Caw harmer 1 9.95 10014 1006 17-lan-18 Hicut chain saw, 16 in. 1 25699 10015 1007 17-Jan-18 7 25-n. pwt.saw bsde 14.99 11-lan-18 Kel-lal fie, 1.8an. fine 4.99 10018 1005 17-Jan-18 PVC pipe, 3.5-n.,8-it 12 5.87

1- Generate a listing of all purchases made by the customers, using the output shown below as your guide. Sort the results by customer code, invoice number, and product description. Cus CODE INV_NUMDEN INV DATE LNE UNITS LINE ICE 1002 16-Jon-18 Rat-tal file, 10-n. fine 1004 17-Jam-10 Claw haTmer 10011 4,99 10011 9.95 10011 1004 17-Jan-18 Ret-tal fle, 1.8-n. fine 3 439 10011 1003 17-Jan-16 Claw harmer 9.95 10011 1009 17-lan-18 PVC pipe, 3.Sin 8-tt in 597 10011 1009 17-Jan-18 Sleel mettinga, 4x8'x1.6", .5" mesh 119.95 10012 1003 16-lan-187 25-n. pw. saw blode 1003 16-Jan-18 B8D cordless ril, 1/2in. 1003 18-lam-10 Hrd deth, 14in., 2x50 14.99 10012 38.95 10012 99.95 10014 1001 16-Jan-18 725-n. pwr. saw blede 14.99 10014 1001 16-lan-18 Claw harmer 995 1003 17-Jan-10 1 25-n. melel screw, 25 17-lan-18 BBD jasaw, 124n. lalade 10014 6.99 10014 100 109.92 10014 1005 17-Jan-18 Caw harmer 1 9.95 10014 1006 17-lan-18 Hicut chain saw, 16 in. 1 25699 10015 1007 17-Jan-18 7 25-n. pwt.saw bsde 14.99 11-lan-18 Kel-lal fie, 1.8an. fine 4.99 10018 1005 17-Jan-18 PVC pipe, 3.5-n.,8-it 12 5.87

Oracle 12c: SQL
Oracle 12c: SQL
3rd Edition
ISBN:9781305251038
Author:Joan Casteel
Publisher:Joan Casteel
Chapter13: Views
Section: Chapter Questions
Problem 3MC
See similar textbooks
icon
Related questions
icon
Concept explainers
Question
1- Generate a listing of all purchases made by the customers, using the output shown below as your guide. Sort the results by customer code, invoice number, and product description. Cus CODE INV_NUMDEN INV DATE r_DESCrarT LNE UNITS LINE ICE 10011 1002 16-Jan-18 Rdt-tal fie, 18-n. 1ne 2 4.99 10011 1004 17-Jan-16 Claw harmer 9.95 1004 17-Jan-18 Rst-tal fie, 1.8-n. fine 1003 17-JaI-10 Claw haTmer 10011 3 499 10011 9.95 10011 1009 17-lan-18 PVC pipe, 3.S-in. 8-tt 587 10011 1003 17-Jan-18 Steel metting, dx8x1.6", .5" mesh 119.95 10012 1003 16-lan-187 25-n. pw saw biode 1003 16-an-18 B8D cordless dril, 1/2in. 16-lan-18 Hrd.deth, 14in., 2x50 1499 10012 10012 38.95 1003 99.95 10014 1001 16-Jan-18 725-in. pw.saw blede 14.99 10014 1001 16-lan-18 Claw harmer 995 1008 17-Jan-10 125-in. etel screw, 25 100S 17-lan-18 B8D jgsaw, 12in. blade 1005 17-Jam-18 Claw hamer 10014 6.99 10014 109.92 10014 1 9.95 17-lan-18 Hicut chnin saw, 16 in. 17-Jan-18 725-n. pwt.saw blede 11-lan-18 Ket-lal hie, 1n. tine 10014 100 296.99 10015 1007 14.99 ILU/ 4.99 10018 1005 17-Jan-18 PVC pipe, 3.5-h.,8-it 12 5.37
Transcribed Image Text:1- Generate a listing of all purchases made by the customers, using the output shown below as your guide. Sort the results by customer code, invoice number, and product description. Cus CODE INV_NUMDEN INV DATE r_DESCrarT LNE UNITS LINE ICE 10011 1002 16-Jan-18 Rdt-tal fie, 18-n. 1ne 2 4.99 10011 1004 17-Jan-16 Claw harmer 9.95 1004 17-Jan-18 Rst-tal fie, 1.8-n. fine 1003 17-JaI-10 Claw haTmer 10011 3 499 10011 9.95 10011 1009 17-lan-18 PVC pipe, 3.S-in. 8-tt 587 10011 1003 17-Jan-18 Steel metting, dx8x1.6", .5" mesh 119.95 10012 1003 16-lan-187 25-n. pw saw biode 1003 16-an-18 B8D cordless dril, 1/2in. 16-lan-18 Hrd.deth, 14in., 2x50 1499 10012 10012 38.95 1003 99.95 10014 1001 16-Jan-18 725-in. pw.saw blede 14.99 10014 1001 16-lan-18 Claw harmer 995 1008 17-Jan-10 125-in. etel screw, 25 100S 17-lan-18 B8D jgsaw, 12in. blade 1005 17-Jam-18 Claw hamer 10014 6.99 10014 109.92 10014 1 9.95 17-lan-18 Hicut chnin saw, 16 in. 17-Jan-18 725-n. pwt.saw blede 11-lan-18 Ket-lal hie, 1n. tine 10014 100 296.99 10015 1007 14.99 ILU/ 4.99 10018 1005 17-Jan-18 PVC pipe, 3.5-h.,8-it 12 5.37
Given a small company database tables below. Create the database and tables for the company and answer all the questions below. LINE CUSTOMER VENDOR INV_NUMBER LINE_NUMBER P_CODE LINE_UNITS LINE_PRICE Cus CODE CUS_LNAME CUS_FNAME CUS_INITIAL cus AREACODE CUS_PHONE CUS_BALANCE V_CODE V_NAME V_CONTACT V_AREACODE V_PHONE V_STATE V_ORDER 1000 3 23100-HB 0.05 10010 Ramas Afred 015 844-2573 21225 Bryson, Ine. Smithson 015 223-3234 TN 1006 4 89-WRE-Q 256.00 10011 Dunne Leona 713 804-1238 21220 SuperLoo, Inc. Flushing 04 215-8006 FL N 1 13-Q2/P2 2 14.00 1007 10012 Smith Kathy 015 804-2205 345.88 21231 DSE Supply Singh 815 228-3246 TN 1007 254778-2T 4.00 10013 Olowski Paul 815 804-2100 530.75 21344 Gomez Bros. Ortega 815 889-2546 KY N 1008 1 PVC23DRT 5.87 10014 Orlando Myron le15 222-1872 22507 Dome Supply Smith 01 e78-1419 GA IN 1008 2 WR3/TT3 3 110.05 10015 OBrian Amy 713 442-3381 23110 Randsets Ltd. Anderson 001 078-3008 GA 1008 3 23100-HB 0.05 10010 Brown James 015 297-1228 221.19 24004 Brackman Bros. Browning 615 228-1410 TN IN 10017 Wiliams George 015 290-2556 788.9 24288 JORDVA, Inc. Hakford 815 e08-1234 TN PRODUCT 10018 Fariss Anne 713 382-7185 25443 BAK, Inc. 904 227-0003 FL 216.55 Smith P_CODE P_DESCRIPT P_INDATE P_QOHP_MIN P_PRICE P_DISCOUNT V_CODE 10019 Smith 015 207-3800 25501|Damal Supplies Smythe 015 e90-3529 TN IN Olette 11QER/31 Power painter, 15 psi, 3-nozzle 03-Nov-17 100.00 0.00 25505 25505 Rubicon Systems Orton 904 450-0002 FL 13-02/P2 7.25-in. pwr. saw blade 13-Dec-17 32 15 14.00 0.05 21344 INVOICE 14-Q1/L3 9.00-in. pwr. saw blade 13-Nov-17 18 12 17.40 0.00 21344 LINE INV_NUMBER CUS_CODE INV_DATE 1548-002 Hrd. cloth, 14-in. 2x50 0.00 23110 15-Jan-18 15 30.95 INV_NUMBER LINE_NUMBER P_CODE LINE_UNITS LINE_PRICE 1001 10014 10-Jan-18 1558-QW1 Hrd. cloth. 1/2-in. 3x50 0.00 23119 15-Jan-18 23 43.00 1001 1 13-Q2/P2 14.00 1 1002 10011 10-Jan-18 2232/QTY BAD igsaw, 12-in, blade 30-Dec-17 100.02 8 0.05 24288 1001 2 23100-HB 1 9.05 1003 10012 16-Jan-18 2232/QWE BAD jgsaw, B-in. blade 24-Deo-17 00.87 0.05 24288 1002 154778-2T 4.00 1004 10011 17-Jan-18 2238/OPD B&D cordless drill, 1/2-in. 20-Jan-18 12 38.95 0.05 25505 1003 1 2238/QPD 38.05 1005 10018 17-Jan-18 23100-HB Ciaw hammer 20-Jan-18 23 10 9.05 0.10 21225 1003 2 1546-Q02 1 39.05 1000 10014 17-Jan-18 23114-AA Sledge hammer, 12 Ib. 02-Jan-18 8 14.4 0.05 1003 3 13-02/P2 5 14.90 1007 10015 17-Jan-18 54778-2T Rat-tail fie. 1/8-in. fine 15-Dec-17 4.90 1004 154778-2T 3. 4.00 43 20 0.00 21344 1008 10011 17-Jan-18 9.05 80-WRE-Q Hicut chain saw, 10 in. 07-Feb-18 1004 2 23109-HB 2 11 256.00 0.05 24288 1005 1 PVC23DRT 12 PVC23DRT PvC pipe. 3.5-in., 8-A 20-Feb-18 188 75 5.87 0.00 5.87 PRODUCT 1006 1 SM-18277 3 0.00 SM-18277 1.25-in. metal screw, 25 01-Mar-18 0.00 21225 172 75 6.00 P CODE P DESCRIPT PINDATE P_QOH P_MIN P_PRICEP_DISCOUNT V_CODE 1006 2 2232/QTY 1 109.92 sw-23116 2.5-in, wd. screw. 50 24-Feb-18 237 100 8.45 0.00 21231 WR3TT3 Steel matting. 4x8x1/8". 5" mesh 17-Jan-18 18 5 119.95 0.10 25606 25595
Transcribed Image Text:Given a small company database tables below. Create the database and tables for the company and answer all the questions below. LINE CUSTOMER VENDOR INV_NUMBER LINE_NUMBER P_CODE LINE_UNITS LINE_PRICE Cus CODE CUS_LNAME CUS_FNAME CUS_INITIAL cus AREACODE CUS_PHONE CUS_BALANCE V_CODE V_NAME V_CONTACT V_AREACODE V_PHONE V_STATE V_ORDER 1000 3 23100-HB 0.05 10010 Ramas Afred 015 844-2573 21225 Bryson, Ine. Smithson 015 223-3234 TN 1006 4 89-WRE-Q 256.00 10011 Dunne Leona 713 804-1238 21220 SuperLoo, Inc. Flushing 04 215-8006 FL N 1 13-Q2/P2 2 14.00 1007 10012 Smith Kathy 015 804-2205 345.88 21231 DSE Supply Singh 815 228-3246 TN 1007 254778-2T 4.00 10013 Olowski Paul 815 804-2100 530.75 21344 Gomez Bros. Ortega 815 889-2546 KY N 1008 1 PVC23DRT 5.87 10014 Orlando Myron le15 222-1872 22507 Dome Supply Smith 01 e78-1419 GA IN 1008 2 WR3/TT3 3 110.05 10015 OBrian Amy 713 442-3381 23110 Randsets Ltd. Anderson 001 078-3008 GA 1008 3 23100-HB 0.05 10010 Brown James 015 297-1228 221.19 24004 Brackman Bros. Browning 615 228-1410 TN IN 10017 Wiliams George 015 290-2556 788.9 24288 JORDVA, Inc. Hakford 815 e08-1234 TN PRODUCT 10018 Fariss Anne 713 382-7185 25443 BAK, Inc. 904 227-0003 FL 216.55 Smith P_CODE P_DESCRIPT P_INDATE P_QOHP_MIN P_PRICE P_DISCOUNT V_CODE 10019 Smith 015 207-3800 25501|Damal Supplies Smythe 015 e90-3529 TN IN Olette 11QER/31 Power painter, 15 psi, 3-nozzle 03-Nov-17 100.00 0.00 25505 25505 Rubicon Systems Orton 904 450-0002 FL 13-02/P2 7.25-in. pwr. saw blade 13-Dec-17 32 15 14.00 0.05 21344 INVOICE 14-Q1/L3 9.00-in. pwr. saw blade 13-Nov-17 18 12 17.40 0.00 21344 LINE INV_NUMBER CUS_CODE INV_DATE 1548-002 Hrd. cloth, 14-in. 2x50 0.00 23110 15-Jan-18 15 30.95 INV_NUMBER LINE_NUMBER P_CODE LINE_UNITS LINE_PRICE 1001 10014 10-Jan-18 1558-QW1 Hrd. cloth. 1/2-in. 3x50 0.00 23119 15-Jan-18 23 43.00 1001 1 13-Q2/P2 14.00 1 1002 10011 10-Jan-18 2232/QTY BAD igsaw, 12-in, blade 30-Dec-17 100.02 8 0.05 24288 1001 2 23100-HB 1 9.05 1003 10012 16-Jan-18 2232/QWE BAD jgsaw, B-in. blade 24-Deo-17 00.87 0.05 24288 1002 154778-2T 4.00 1004 10011 17-Jan-18 2238/OPD B&D cordless drill, 1/2-in. 20-Jan-18 12 38.95 0.05 25505 1003 1 2238/QPD 38.05 1005 10018 17-Jan-18 23100-HB Ciaw hammer 20-Jan-18 23 10 9.05 0.10 21225 1003 2 1546-Q02 1 39.05 1000 10014 17-Jan-18 23114-AA Sledge hammer, 12 Ib. 02-Jan-18 8 14.4 0.05 1003 3 13-02/P2 5 14.90 1007 10015 17-Jan-18 54778-2T Rat-tail fie. 1/8-in. fine 15-Dec-17 4.90 1004 154778-2T 3. 4.00 43 20 0.00 21344 1008 10011 17-Jan-18 9.05 80-WRE-Q Hicut chain saw, 10 in. 07-Feb-18 1004 2 23109-HB 2 11 256.00 0.05 24288 1005 1 PVC23DRT 12 PVC23DRT PvC pipe. 3.5-in., 8-A 20-Feb-18 188 75 5.87 0.00 5.87 PRODUCT 1006 1 SM-18277 3 0.00 SM-18277 1.25-in. metal screw, 25 01-Mar-18 0.00 21225 172 75 6.00 P CODE P DESCRIPT PINDATE P_QOH P_MIN P_PRICEP_DISCOUNT V_CODE 1006 2 2232/QTY 1 109.92 sw-23116 2.5-in, wd. screw. 50 24-Feb-18 237 100 8.45 0.00 21231 WR3TT3 Steel matting. 4x8x1/8". 5" mesh 17-Jan-18 18 5 119.95 0.10 25606 25595
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Query Syntax
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
CMPTR
CMPTR
Computer Science
ISBN:
9781337681872
Author:
PINARD
Publisher:
Cengage
Programming with Microsoft Visual Basic 2017
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS