Write SQL and Python, run instantly in your browser, and track your progress.
You are a Category Manager at Target, responsible for the Electronics department. For an upcoming marketing campaign, the team wants to create a 'Top Tech' feature on the website's homepage, showcasing high-end, actively sold electronics.
Your task is to generate this list of premium products. You need to query the products table to find all items in the 'Electronics' category that are currently active for sale (is_active = 1) and have a price of $200 or more.
To ensure the most expensive items are featured most prominently, the final list must be sorted by price from highest to lowest. If any products share the same price, the one with the smaller product_id should be listed first.
| Column Name | Type |
|---|---|
You are a Category Manager at Target, responsible for the Electronics department. For an upcoming marketing campaign, the team wants to create a 'Top Tech' feature on the website's homepage, showcasing high-end, actively sold electronics.
Your task is to generate this list of premium products. You need to query the products table to find all items in the 'Electronics' category that are currently active for sale (is_active = 1) and have a price of $200 or more.
To ensure the most expensive items are featured most prominently, the final list must be sorted by price from highest to lowest. If any products share the same price, the one with the smaller product_id should be listed first.
| Column Name | Type |
|---|---|
| product_id |
| product_id |
| INTEGER |
| INTEGER |
| sku | TEXT |
| sku | TEXT |
| product_name | 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 |
|---|---|---|---|
| 42 | Bose QuietComfort 45 | Electronics | 329.99 |
| 21 | Apple Magic Keyboard | Electronics | 299.99 |
| 37 | Apple AirPods Pro 2nd Gen | Electronics | 249.99 |
| product_id | product_name | category | price |
|---|---|---|---|
| 42 | Bose QuietComfort 45 | Electronics | 329.99 |
| 21 | Apple Magic Keyboard | Electronics | 299.99 |
| 37 | Apple AirPods Pro 2nd Gen | Electronics | 249.99 |
3 rows returned. These are the premium Electronics products priced at $200+.
3 rows returned. These are the premium Electronics products priced at $200+.
Your final output should be a result set that meets the following requirements:
1. Filtering:
is_active is 1).price is greater than or equal to 200.2. Columns:
product_idproduct_namecategoryYour final output should be a result set that meets the following requirements:
1. Filtering:
is_active is 1).price is greater than or equal to 200.2. Columns:
product_idproduct_namecategory| 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 |
priceprice3. Ordering:
3. Ordering:
price in descending order (highest first).product_id in ascending order.price in descending order (highest first).product_id in ascending order.