Question: 6 . [ SQL Week 2 Question 2 0 0 - 5 0 6 ] Last one! You want to know how many times products

6.[SQL Week 2 Question 200-506] 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.
a. Include all products, even if they had no shipments. In this case, their count would be 0.
b. Include the manufacturer and the product name
c. Include the customer company name
d. Sort it so the smallest count of shipments is on top. After that, sort ascending by Manufacturer name and then product name.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!