Write SQL and Python, run instantly in your browser, and track your progress.
You are a Pricing Strategist at Amazon. The Category Management team needs to understand the price distribution within each product category. For each category, calculate the number of products, minimum price, maximum price, and price range (max - min).
| Column Name | Type |
|---|---|
| product_id | int64 |
| sku | object |
| product_name | object |
| category | object |
You are a Pricing Strategist at Amazon. The Category Management team needs to understand the price distribution within each product category. For each category, calculate the number of products, minimum price, maximum price, and price range (max - min).
| Column Name | Type |
|---|---|
| product_id | int64 |
| sku | object |
| product_name | object |
| category | object |
| price | float64 |
| price | float64 |
| currency | object |
| currency | object |
| is_active | int64 |
| is_active | int64 |
| weight_kg | float64 |
| weight_kg | float64 |
| created_at | object |
| created_at | object |
| product_id | sku | product_name | category | price | currency | is_active | weight_kg | created_at |
|---|---|---|---|---|---|---|---|---|
| 1 | SKU-10001 | Casper Original Mattress Queen | Home | 1095.0 | USD |
| product_id | sku | product_name | category | price | currency | is_active | weight_kg | created_at |
|---|---|---|---|---|---|---|---|---|
| 1 | SKU-10001 | Casper Original Mattress Queen | Home | 1095.0 | USD |
| category | product_count | min_price | max_price | price_range |
|---|---|---|---|---|
| Home | 7 | 149.99 | 1095 | 945.01 |
| Office | 5 | 54.99 | 599 | 544.01 |
| Beauty | 6 | 19.99 | 429.99 | 410 |
| category | product_count | min_price | max_price | price_range |
|---|---|---|---|---|
| Home | 7 | 149.99 | 1095 | 945.01 |
| Office | 5 | 54.99 | 599 | 544.01 |
| Beauty | 6 | 19.99 | 429.99 | 410 |
Showing first 5 of 8 rows.
Showing first 5 of 8 rows.
1. Grouping:
2. Aggregation:
3. Output:
1. Grouping:
2. Aggregation:
3. Output:
| 1 |
| 1 |
| 31.75 |
| 31.75 |
| 2025-02-14 10:57:38 |
| 2025-02-14 10:57:38 |
| 2 | SKU-10002 | Dyson Supersonic Hair Dryer | Beauty | 429.99 | USD | 1 | 0.66 | 2025-02-27 07:20:29 |
| 2 | SKU-10002 | Dyson Supersonic Hair Dryer | Beauty | 429.99 | USD | 1 | 0.66 | 2025-02-27 07:20:29 |
| 3 | SKU-10003 | CalDigit TS4 Thunderbolt Dock | Office | 399.99 | USD | 1 | 0.5 | 2024-12-11 00:49:57 |
| 3 | SKU-10003 | CalDigit TS4 Thunderbolt Dock | Office | 399.99 | USD | 1 | 0.5 | 2024-12-11 00:49:57 |
| 4 | SKU-10004 | Under Armour Tech 2.0 T-Shirt | Sports | 25.0 | USD | 1 | 0.15 | 2024-11-22 04:49:00 |
| 4 | SKU-10004 | Under Armour Tech 2.0 T-Shirt | Sports | 25.0 | USD | 1 | 0.15 | 2024-11-22 04:49:00 |
| 5 | SKU-10005 | Staples TRU RED Copy Paper 10-Ream | Office | 54.99 | USD | 1 | 22.68 | 2025-01-10 01:43:59 |
| 5 | SKU-10005 | Staples TRU RED Copy Paper 10-Ream | Office | 54.99 | USD | 1 | 22.68 | 2025-01-10 01:43:59 |
| Toys | 10 | 21.99 | 349.99 | 328 |
| Toys | 10 | 21.99 | 349.99 | 328 |
| Sports | 6 | 25 | 349.99 | 324.99 |
| Sports | 6 | 25 | 349.99 | 324.99 |