Products launched in 2024
easyProducts launched in 2024
Target SQL Interview Question
Target's marketing team is putting together a New in 2024 section on Target.com.
List the product_name and launch_date of every product launched in 2024.
Asked of
- Data Analyst
- Business Analyst
- BI Analyst
- Product Analyst
- Analytics Engineer
- Data Engineer
- Data Scientist
- ML Engineer
- AI Engineer
productsTable15 rows
| Column Name | Type |
|---|---|
| product_id | BIGINT |
| product_name | VARCHAR |
| category | VARCHAR |
| brand | VARCHAR |
| price | DOUBLE |
| discount_pct | BIGINT |
| stock_quantity | BIGINT |
| launch_date | DATE |
| is_active | BOOLEAN |
productsExample Input
| product_id | product_name | category | brand | price | discount_pct | stock_quantity | launch_date | is_active |
|---|---|---|---|---|---|---|---|---|
| 8 | Notebook Set | Stationery | Moleskine | 18 | NULL | 0 | 2022-09-01 | false |
| 9 | Gel Pen Pack | Stationery | NULL | 6.99 | NULL | 500 | 2024-02-10 | true |
| 10 | Laptop Stand | Accessories | Rain Design | 49.99 | 10 | 60 | 2023-10-05 | true |
| 11 | Webcam Pro 4K | Electronics | Logitech | 149 | NULL | 25 | 2024-03-18 | true |
| 12 | Monitor Arm | Accessories | NULL | 89 | 25 | 0 | 2022-12-12 | false |
| 13 | Cable Organizer | Accessories | NULL | 12.5 | NULL | 300 | 2024-04-01 | true |
| 14 | Portable SSD 1TB | Electronics | Samsung | 109.99 | 12 | 35 | 2023-07-17 | true |
| 15 | Whiteboard | Stationery | Quartet | 65 | NULL | 18 | 2021-11-11 | false |
Example Output
| product_name | launch_date |
|---|---|
| Cable Organizer | 2024-04-01 |
| Gel Pen Pack | 2024-02-10 |
| Webcam Pro 4K | 2024-03-18 |
Explanation
The Gel Pen Pack, Webcam Pro 4K and Cable Organizer were launched in February, March and April 2024. The other products in the example were launched in 2021, 2022 or 2023, so they are left out.
The example above is a small slice of the data. Your query runs against the full tables.
Company
Target
Difficulty
easy
Topic
dates
Your query
Starting the SQL engine...