Using the output shown in Figure P7.12 as your guide, generate a list of customer purchases, including the subtotals for each of the invoice line numbers. The subtotal is a derived attribute calculated by multiplying LINE_UNITS by LINE_PRICE. Sort the output by customer code, invoice number, and product description. Be certain to use the columnaliases as shown in the figure.FIGURE P7.12 SUMMARY OF CUSTOMER PURCHASES WITH SUBTOTALS CUS CODE INV NUMBER10011Unts BoughtSubtulal9.9819.9014.979.9529.35359.8574.9538.9539.9514.999.9520.97109.929.95256.9929.984.9970.44P DESCRIPTUnt Price1002 Rat-tal lile, 1/8-in. fine4.99100111004 Claw hammer29.95100111004 Rat-tai fila, 1/8-in. fine4.99100111008 Claw hammer9.951008 PVC pipe, 3.5-in. 8-A1008 Steel matting, 4x8x1/6", 5" mesh1003 7.25-n. pwr. saw blade1003 BAD cordless dril, 1/2-in.1003 Hrd. cloth, 14-in., 2601001 7.25-in. pwr. saw blade100115.8710011119.951001214.991001238.951001239.951001414,99100141001 Claw hammer9.95100141006 1.25-in. matal scrow, 256.991006 B&D jigsaw, 12-n. blade1006 Claw hammer1006 Hicut chain naw, 16 in109.9210014100149.951001410015256.991007 7 25-in. pwr. saw blade1007 Ral-tai file, 1/8-in. fine214.99100164.99100181005 PVC pipe, 3.5-in. 8A125.87

Required : SQL query Output given :

Answered: CUS CODE INV NUMBER 10011 Unts Bought…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

Using the output shown in Figure P7.12 as your guide, generate a list of customer purchases, including the subtotals for each of the invoice line numbers. The subtotal is a derived attribute calculated by multiplying LINE_UNITS by LINE_PRICE. Sort the output by customer code, invoice number, and product description. Be certain to use the column
aliases as shown in the figure.

FIGURE P7.12 SUMMARY OF CUSTOMER PURCHASES WITH SUBTOTALS