Write SQL and Python, run instantly in your browser, and track your progress.
You are a Product Catalog Manager at Amazon. The merchandising team is preparing a cross-category promotional campaign that will feature products from both the Electronics and Home departments. They need a unified inventory list of all active products from these two categories to plan the campaign budget and assess available stock.
Your task is to create a single list that combines all active products from Electronics with all active products from Home, ensuring no duplicates appear in the final result.
| Column Name | Type |
|---|---|
| product_id | INTEGER |
| sku | TEXT |
| product_name | TEXT |
You are a Product Catalog Manager at Amazon. The merchandising team is preparing a cross-category promotional campaign that will feature products from both the Electronics and Home departments. They need a unified inventory list of all active products from these two categories to plan the campaign budget and assess available stock.
Your task is to create a single list that combines all active products from Electronics with all active products from Home, ensuring no duplicates appear in the final result.
| Column Name | Type |
|---|---|
| product_id | INTEGER |
| sku | TEXT |
| product_name | TEXT |
| category | TEXT |
| category | 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 |
|---|---|---|---|
| 9 | Samsung Galaxy Buds2 Pro | Electronics | 199.99 |
| 10 | Xbox Wireless Controller | Electronics | 64.99 |
| 12 | Fire TV Stick 4K Max | Electronics | 54.99 |
| 21 | Apple Magic Keyboard | Electronics |
| product_id | product_name | category | price |
|---|---|---|---|
| 9 | Samsung Galaxy Buds2 Pro | Electronics | 199.99 |
| 10 | Xbox Wireless Controller | Electronics | 64.99 |
| 12 | Fire TV Stick 4K Max | Electronics | 54.99 |
| 21 | Apple Magic Keyboard | Electronics |
Showing first 5 of 16 rows. Active products from Electronics and Home categories combined.
Showing first 5 of 16 rows. Active products from Electronics and Home categories combined.
1. Output Columns:
2. Set Operation:
3. Ordering:
1. Output Columns:
2. Set Operation:
3. Ordering:
| 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 |
| 299.99 |
| 299.99 |
| 30 | Google Nest Mini | Electronics | 49.99 |
| 30 | Google Nest Mini | Electronics | 49.99 |