Question: 6 . [ SQL Week 2 Question 2 0 0 - 5 0 6 ] Last one! You want to know how many times products
SQL Week Question 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 items and one shipment of items would be two shipments, not items.
a Include all products, even if they had no shipments. In this case, their count would be
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
