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

 

Transcribed Image Text:

5. You want to report on a certain group of your products. Select a. Only customers who have a balance of 0 b. Only shipments which were sent by employees whose employee location is California, Maryland, or New York c. Only products which have had a shipment d. Only employees who have made a shipment e. Only customers who have received a shipment f. Compute the total quantity of shipments which meet these criteria. Here we want the number of items shipped. If you have one shipment of 10 items, and another shipment of 20 items, this number should be 30. g. 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. h. 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 a little bit like this. Your data may or may not match this example. 1 2 3 4 5 6 7 8 Input example: Shipment ID Output example: Manufacturer Alpha Mig Alpha Mi Alpha Mig Beta Mig Alpha Mi Alpha Mig Alpha Mig Beta Mig Manufacturer Alpha Mig Beta Mig Alpha Mfg Alpha Mfg Product Name Gamma Zap Gamma Zap Gamma Zap Gamma Zap Delta Cross Delta Cross Epsilon Ray Frank Zappa Product Name Gamma Zap Frank Zappa Epsilon Ray Delta Cross Shipment 5 5 5 10 6 1 8 10 Total Shipment Quantity 15 10 8 7 5. You want to report on a certain group of your products. Select a. Only customers who have a balance of 0 b. Only shipments which were sent by employees whose employee location is California, Maryland, or New York c. Only products which have had a shipment d. Only employees who have made a shipment e. Only customers who have received a shipment f. Compute the total quantity of shipments which meet these criteria. Here we want the number of items shipped. If you have one shipment of 10 items, and another shipment of 20 items, this number should be 30. g. 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. h. 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 a little bit like this. Your data may or may not match this example. 1 2 3 4 5 6 7 8 Input example: Shipment ID Output example: Manufacturer Alpha Mig Alpha Mi Alpha Mig Beta Mig Alpha Mi Alpha Mig Alpha Mig Beta Mig Manufacturer Alpha Mig Beta Mig Alpha Mfg Alpha Mfg Product Name Gamma Zap Gamma Zap Gamma Zap Gamma Zap Delta Cross Delta Cross Epsilon Ray Frank Zappa Product Name Gamma Zap Frank Zappa Epsilon Ray Delta Cross Shipment 5 5 5 10 6 1 8 10 Total Shipment Quantity 15 10 8 7