Question

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.


$1.99
Sales0
Views133
Comments0
  • CreatedDecember 03, 2014
  • Files Included
Post your question
5000