Purchase Answers for $5

Question 5 (2 points) Question 5 options:[SQL Week 2

Question 5 (2 points)

 

Question 5 options:

[SQL Week 2 Question 200-505] 

You want to report on a certain group of your products. Select

Only customers who have a balance of 0

Only shipments which were sent by employees whose employee location is California, Maryland, or New York

Only products which have had a shipment

Only employees who have made a shipment

Only customers who have received a shipment

Compute the total quantity of shipments which meet these criteria

Aggregate it by manufacturer and by product name. This means each manufacturer/product name combination appears on only one row in the table. If a manufacturer makes more than one product, it’s OK if it shows up once per product.

Sort it descending by the sum of the shipment quantity, so the largest shipment quantity shows up on top. Within shipment quantities, sort it alphabetically on manufacturer and then product name.

Your results should look something like this:

What is the total shipment quantity for General Widgets' "Widget Maximus" product?  This would be in the green "A"  in the screenshot above.

 

Which company had Total Shipments of 2 for the Twisters?  This would show up in the blue letter "B" above.

 

Drill Bits R Us

Question 6 (2 points)

 



Answers are locked, Purchase answers for $5.