What’s the most popular product type (hierarchy 1) sold in all stores over a week? How much revenue did the stores receive for that product during the week? How does that compare with the second most popular product? Provide a table that shows the product type ranked from most to least popular. For each product type provide: how many subtypes (hierarchy 2) are there, how many products are in this product type, what’s the sales quantity, and the revenue generated.

  

Transcribed Image Text:

product_id store_id date sales_ug sales revenue stock price promo_type_1 promo_bin_1 promo_discount_2 promo_discount_type_2 P0001 S0002 2017-07-03 0 0 1 6.75 PR14 NA P0001 S0038 2017-07-03 0 0 1 6.75 PR14 P0001 S0040 2017-07-03 0 0 2 6.75 PR14 NA P0001 S0050 2017-07-03 0 0 1 6.75 PR14 NA P0001 S0103 2017-07-03 0 0 10 6.75 PR14 NA P0001 S0105 2017-07-03 0 0 5 6.75 PR14 P0002 S0038 2017-07-03 0 0 24 349 PR14 P0002 S0085 2017-07-03 0 0 25 349 PR14 P0004 S0085 2017-07-03 0 0 7 4.5 PR14 P0005 S0001 2017-07-03 0 0 3 33.9 PR14 3 3 3 3 3 NA P0005 S0002 2017-07-03 0 0 10 33.9 PR14 NA P0005 S0008 2017-07-03 0 0 9 33.9 PR14 NA P0005 S0012 2017-07-03 0 0 6 33.9 PR14 NA P0005 S0013 2017-07-03 0 0 4 33.9 PR14 P0005 S0017 2017-07-03 0 0 4 33.9 PR14 NA P0005 S0020 2017-07-03 0 0 2 33.9 PR14 NA P0005 S0023 2017-07-03 0 0 8 33.9 PR14 NA P0005 S0024 2017-07-03 0 0 P0005 S0026 2017-07-03 1 28.73 P0005 S0031 2017-07-03 0 0 P0005 S0038 2017-07-03 0 P0005 S0040 2017-07-03 0 O O 0 6667 33.9 PR14 33.9 PR14 NA 33.9 PR14 NA 33.9 PR14 0 P0005 S0042 2017-07-03 0 0 12 P0005 S0043 2017-07-03 0 0 12 522 33.9 PR14 33.9 PR14 33.9 PR14 P0005 S0050 2017-07-03 0 0 4 33.9 PR14 P0005 S0051 2017-07-03 0 0 2 33.9 PR14 3 3 3 3 3 NA NA NA P0005 S0056 2017-07-03 0 0 7 33.9 PR14 NA product_id store_id date sales_ug sales revenue stock price promo_type_1 promo_bin_1 promo_discount_2 promo_discount_type_2 P0001 S0002 2017-07-03 0 0 1 6.75 PR14 NA P0001 S0038 2017-07-03 0 0 1 6.75 PR14 P0001 S0040 2017-07-03 0 0 2 6.75 PR14 NA P0001 S0050 2017-07-03 0 0 1 6.75 PR14 NA P0001 S0103 2017-07-03 0 0 10 6.75 PR14 NA P0001 S0105 2017-07-03 0 0 5 6.75 PR14 P0002 S0038 2017-07-03 0 0 24 349 PR14 P0002 S0085 2017-07-03 0 0 25 349 PR14 P0004 S0085 2017-07-03 0 0 7 4.5 PR14 P0005 S0001 2017-07-03 0 0 3 33.9 PR14 3 3 3 3 3 NA P0005 S0002 2017-07-03 0 0 10 33.9 PR14 NA P0005 S0008 2017-07-03 0 0 9 33.9 PR14 NA P0005 S0012 2017-07-03 0 0 6 33.9 PR14 NA P0005 S0013 2017-07-03 0 0 4 33.9 PR14 P0005 S0017 2017-07-03 0 0 4 33.9 PR14 NA P0005 S0020 2017-07-03 0 0 2 33.9 PR14 NA P0005 S0023 2017-07-03 0 0 8 33.9 PR14 NA P0005 S0024 2017-07-03 0 0 P0005 S0026 2017-07-03 1 28.73 P0005 S0031 2017-07-03 0 0 P0005 S0038 2017-07-03 0 P0005 S0040 2017-07-03 0 O O 0 6667 33.9 PR14 33.9 PR14 NA 33.9 PR14 NA 33.9 PR14 0 P0005 S0042 2017-07-03 0 0 12 P0005 S0043 2017-07-03 0 0 12 522 33.9 PR14 33.9 PR14 33.9 PR14 P0005 S0050 2017-07-03 0 0 4 33.9 PR14 P0005 S0051 2017-07-03 0 0 2 33.9 PR14 3 3 3 3 3 NA NA NA P0005 S0056 2017-07-03 0 0 7 33.9 PR14 NA

Answer rating: 100% (QA)

To provide the information requested I would need access to the sales data for all stores over ... View the full answer