Generate a listing of all purchases made by the customers. (Hint: Multiple related tables need to be joined). Only parts of result are shown below. CU8000 IN NUMBER IN DATE 13011 100 m SH 3008 10011 1000 10014 2035 10012 13012 00:12 10011 10011 10011 20014 10004 181 201 DESCRIPT ALIEN, S4. THE 201401-35010000 201401-17000 Came 2014-01-1700:00:00 28 20140117000 Con 2441-17000 P 20140-1700:00 Saluting, 45x45,5 m3 201400-18000 7.25 20-0 2014-01-150:00:00 Hidd 211401300:00:00 7.25 LINE JUNCTS LINE PROCE *** 4.35 DATELLING DATE 2014-01-16 2014-01-17 1.39 9.95 5.37 LES SS 14,79 14.09 The results in question 11 show the sales history on 2014-01-16 and 2014-01-17. Based on the query in question 12, write a new query to computer each day's total sales amount. The exact return result is shown below. SUMO LINE UNITS LLINE PRICE 188.77 937.26 13. Generate a listing of customer purchases, including a new column called subtotal (unit_price* units bought) foreach line in the invoice. Only parts of result are shown below. OUS_CODE INV_NUMBER 10011 10011 10011 10011 10011 10011 10012 10012 10012 10014 10014 1002 1004 1004 1008 1008 1008 1003 1003 1003 1001 1001 P_DESCRIPT Rat-tail file, 1/8-in. fine Claw hammer Rat-tail file, 1/8-in. fine Claw hammer PVC pipe, 3.5th., 8-ft Steel matting, 4x8x1/6,.5"mesh 7.25-n. pwr. saw blade 880 cordless dril, 1/24n. Hrd. doth, 1/4-in., 2x50 7.25-in. pwr. saw blade Claw hammer 215.55 0 345.86 0 0 216.55 Units Bought Unit Price Subtotal 2 4.99 2 9.95 3 4.99 1 9.95 5 5.87 119.95 14.99 38.95 39.95 14.99 9.95 5 3 5 3 2 1 S 1 1 1 14. Modify the query used in question 13 to produce the summary shown below, i.e., return purchase amount foreach customer. CUS_CODE CUS_BALANCE Total_Purchases 10011 444.00 10012 153.85 10014 422.77 10015 34.97 10018 70.44 9.98 19.90 14.97 9.95 29.35 359,85 15. Modify the query in question 14 to include the number of individual product purchases made by each customer. (In other words, if the customer's invoice is based on three products, one per LINE_NUMBER, you would count three product purchases. If you examine the original invoice data, you will note that customer 10011 generated three invoices, which contained a total of six lines, each representing a product purchase.) The exact return result is shown below. CLS CODE CLS BALANCE Total Purchases Number of Purchases 10011 0 444.00 10012 345.96 153.85 10014 0 422.77 10015 0 34.97 10018 70.44 74.95 38.95 39.95 14.99 9.95 VENDOR *V_CODE OV NAME OV_CONTACT OV AREACODE V_PHONE OV_STATE OV ORDER Indexes F PRODUCT P_COOE OP_DESCRIPT OP_INDATE OP_QOH OP MIN OP_PRICE OP_DISCOUNT OV_CODE Indexes FH- EMP EMP NUM EMP TITLE EMP LHAME EMF FNAME EMP INITIAL EMP DOB EMP HIRF DATE EMP AREACODE EMP_PHONE EMP_MGR Indexus LINE LINE NUMBER OLINE UNITS +LINE PRICE INV_NUMBER P_CODE Indexes -It CUSTOMER CUS_CODE CUS LNAME CUS_NAME CUS INITIAL CUS_AREACODE CUS PHONE CUS BALANCE Indexes INVOICE Y INV NUMBER INV DATE CUS_CODE Indexes