Write SQL and Python, run instantly in your browser, and track your progress.
You are a Pricing Strategy Analyst at Target. The team needs to identify premium-priced products within each category that exceed the average price point for competitive positioning analysis. These above-average items represent opportunities for margin optimization, promotional targeting, and inventory management decisions. The merchandising team uses this data to understand which products command premium pricing and adjust category strategies accordingly.
| Column Name | Type |
|---|---|
| product_id | INTEGER |
| sku | TEXT |
| product_name | TEXT |
You are a Pricing Strategy Analyst at Target. The team needs to identify premium-priced products within each category that exceed the average price point for competitive positioning analysis. These above-average items represent opportunities for margin optimization, promotional targeting, and inventory management decisions. The merchandising team uses this data to understand which products command premium pricing and adjust category strategies accordingly.
| Column Name | Type |
|---|---|
| product_id | INTEGER |
| sku | TEXT |
| product_name | TEXT |
| category |
| 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 | price |
|---|---|---|---|
| 1 | Casper Original Mattress Queen | Home | 1095.0 |
| 44 | All-Clad D3 Stainless 10-Piece | Home | 699.99 |
| 38 | Uplift V2 Standing Desk | Office | 599.0 |
| 2 | Dyson Supersonic Hair Dryer | Beauty |
| product_id | product_name | category | price |
|---|---|---|---|
| 1 | Casper Original Mattress Queen | Home | 1095.0 |
| 44 | All-Clad D3 Stainless 10-Piece | Home | 699.99 |
| 38 | Uplift V2 Standing Desk | Office | 599.0 |
| 2 | Dyson Supersonic Hair Dryer | Beauty |
Showing first 5 of 19 rows. Active products priced above category average.
Showing first 5 of 19 rows. Active products priced above category average.
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 |
| 429.99 |
| 429.99 |
| 3 | CalDigit TS4 Thunderbolt Dock | Office | 399.99 |
| 3 | CalDigit TS4 Thunderbolt Dock | Office | 399.99 |
Sorting Requirements:
Sorting Requirements: