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.

Transcribed Image Text:

Figure P7.12 Summary of Customer Purchases with Subtotals CUS_CODE INV_NUMBER 10011 10011 10011 10011 10011 10011 10012 10012 10012 10014 10014 10014 10014 10014 10014 10015 10015 10018 P_DESCRIPT 1002 Rat-tail file, 1/8-in. fine 1004 Claw hammer 1004 Rat-tail file, 1/8-in. fine 1008 Claw hammer 1008 PVC pipe, 3.5-in., 8-ft 1008 Steel matting, 4x8x1/6", 5" mesh 1003 7.25-in. pwr. saw blade 1003 B&D cordless drill, 1/2-in. 1003 Hrd. cloth, 1/4-in., 2x50 1001 7.25-in. pwr. saw blade 1001 Claw hammer 1006 1.25-in. metal screw, 25 1006 B&D jigsaw, 12-in. blade 1006 Claw hammer 1006 Hicut chain saw, 16 in. 1007 7.25-in. pwr. saw blade 1007 Rat-tail file, 1/8-in. fine 1005 PVC pipe, 3.5-in., 8-ft Units Bought 2 2 3 1 5 3 5 1 1 1 1 3 1 1 1 2 1 12 Unit Price 4.99 9.95 4.99 9.95 5.87 119.95 14.99 38.95 39.95 14.99 9.95 6.99 109.92 9.95 256.99 14.99 4.99 5.87 Subtotal 9.98 19.90 14.97 9.95 29.35 359.85 74.95 38.95 39.95 14.99 9.95 20.97 109.92 9.95 256.99 29.98 4.99 70.44