Write SQL and Python, run instantly in your browser, and track your progress.
You are a Product Analyst at Target. Merchandising wants to review inactive items at the low end of pricing for potential clearance decisions. Provide the item identifier, name, segment, and price. Include only inactive items priced below a low threshold. Sort from lowest price to highest; break ties by the smallest identifier.
| Column Name | Type |
|---|---|
| product_id | INTEGER |
| sku | TEXT |
| product_name | TEXT |
| category |
You are a Product Analyst at Target. Merchandising wants to review inactive items at the low end of pricing for potential clearance decisions. Provide the item identifier, name, segment, and price. Include only inactive items priced below a low threshold. Sort from lowest price to highest; break ties by the smallest identifier.
| 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 | price |
|---|---|---|---|
| 14 | It Ends with Us by Colleen Hoover | Books | 16.99 |
| product_id | product_name | category | price |
|---|---|---|---|
| 14 | It Ends with Us by Colleen Hoover | Books | 16.99 |
1 row returned.
1 row returned.
1. Output Columns: - product ID - product name - category - price 2. Filtering: - Include only inactive products (is_active = 0) - Price must be below $20 (price < 20) 3. Ordering: - Sort by price (ascending) - Tie-breaker: product_id (ascending)
1. Output Columns: - product ID - product name - category - price 2. Filtering: - Include only inactive products (is_active = 0) - Price must be below $20 (price < 20) 3. Ordering: - Sort by price (ascending) - Tie-breaker: product_id (ascending)
| 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 |