Write SQL and Python, run instantly in your browser, and track your progress.
You are a Logistics Analyst at Amazon. The Fulfillment Operations team needs to identify lightweight products that can be bundled efficiently to maximize shipping capacity and reduce costs. Products below average weight represent opportunities for optimized packaging configurations and can help determine cost-effective shipping strategies for various product categories.
| Column Name | Type |
|---|---|
| product_id | INTEGER |
| sku | TEXT |
| product_name | TEXT |
| category |
You are a Logistics Analyst at Amazon. The Fulfillment Operations team needs to identify lightweight products that can be bundled efficiently to maximize shipping capacity and reduce costs. Products below average weight represent opportunities for optimized packaging configurations and can help determine cost-effective shipping strategies for various product categories.
| Column Name | Type |
|---|---|
| product_id | INTEGER |
| sku | TEXT |
| product_name | TEXT |
| category |
| TEXT |
| TEXT |
| price | REAL |
| price | REAL |
| currency | TEXT |
| currency | TEXT |
| is_active | INTEGER |
| is_active | INTEGER |
| weight_kg | REAL |
| weight_kg | REAL |
| created_at | TEXT |
| created_at | TEXT |
| 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 |
| product_id | product_name | category | weight_kg |
|---|---|---|---|
| 24 | MAC Ruby Woo Lipstick | Beauty | 0.01 |
| 19 | Ray-Ban Aviator Classic | Apparel | 0.03 |
| 12 | Fire TV Stick 4K Max | Electronic | 0.04 |
| 9 | Samsung Galaxy Buds2 Pro | Electronic |
| product_id | product_name | category | weight_kg |
|---|---|---|---|
| 24 | MAC Ruby Woo Lipstick | Beauty | 0.01 |
| 19 | Ray-Ban Aviator Classic | Apparel | 0.03 |
| 12 | Fire TV Stick 4K Max | Electronic | 0.04 |
| 9 | Samsung Galaxy Buds2 Pro | Electronic |
Showing first 5 of 39 rows. Products below average weight.
Showing first 5 of 39 rows. Products below average weight.
Output Requirements:
Business Logic:
Data Quality:
Output Requirements:
Business Logic:
Data Quality:
| 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 |
| 0.05 |
| 0.05 |
| 11 | Garmin Forerunner 255 | Sports | 0.05 |
| 11 | Garmin Forerunner 255 | Sports | 0.05 |
Sorting Requirements:
Sorting Requirements: