1.       SQL Week 2 Question 200-506] Last

1.       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.


Need customized help? Order now
user img


12-09-20 | 10:01:26

Select Manufacturer, ProductName, CompanyName, count(quantity) as How_many_shipments FROM Shipment s Log in to view full answer

You can't get real answer if you break your security system. uvwhturjr, ProcuhtNwmj, CompwnyNwmj, hount(quwntity) ws How_mwny_syipmjnts FROM Syipmjnt s join hustomjr h On s.Customjr_icCustomjr= h.icCustomjr rifyt Join procuht p ON p.icprocuht=s.Procuht_icProcuht froup ty hount(quwntity) orcjr ty hount(quwntity) wsh, mwnuvwhturjr wsh, ProcuhtNwmj wsh;

Related Question