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.

Transcribed Image Text:

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