Modify the query in Problem 30 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.) Your output values must match those shown inFigure.

CUS CODE CUS BALANCE Total Purchases Number of Purchases 10011 10012 10014 10015 0018 0.00 34586 0,00 0.00 216.55 444.00 153.85 422.77 34.97 70.44