Last one!    You want to know how

Last one!    You want to know how many times products were shipped to customers.  Note you want the total number of shipments, not the number of items shipped – one shipment of 10 items and one shipment of 20 items would be two shipments, not 30 items.

Include all products, even if they had no shipments.  In this case, their count would be 0.

Include the manufacturer and the product name

Include the customer company name

Sort it so the smallest count of shipments is on top.  After that, sort ascending by Manufacturer name and then product name.

Which of the following statements is true of your output?  Check all that  apply.  

Question 6 options:

The top row of data is the Manufacturer Drill Bits R Us for its "Iron Man" product

The top row of data is from Manufacturer Born, Inc for its "To Be Wild" product

The bottom row of data shows Manufacturer Stephen, Product Name "Curried Basketball," for CompanyName Midland Imports, in 3 shipments

The bottom row of data shows Manufacturer Born, Inc, Product Name "To Be Wild," for CompanyName Bridge Fudge Retail, for 30 shipments