Sellers With No Sales
ASKED IN INTERVIEWEtsy
Problem Statement
Etsy administration wants to send a re-engagement email to sellers who were inactive in 2025.
Write an SQL query to report the names of all sellers who did not have any sales in the year 2025.
Rules:
- A seller is considered to have no sales if they do not appear in the Sales table for any date in 2025.
- Output column: seller_name.
- Results must be sorted by seller_name in ascending order.
Tests your understanding of
Joins, Filtering and Date Handling
Input Tables
Sellers
| seller_id(INTEGER) | seller_name(VARCHAR) |
|---|---|
| 1 | ArtisanAbby |
| 2 | BohoBob |
| 3 | CraftyChris |
Orders
| order_id(INTEGER) | seller_id(INTEGER) | sale_date(DATE) |
|---|---|---|
| 101 | 1 | 2025-01-01 |
| 102 | 2 | 2024-12-31 |
| 103 | 2 | 2026-01-01 |
Seller_Stats
| seller_id(INTEGER) | rating(DECIMAL) |
|---|---|
| 1 | 4.8 |
| 2 | 3.5 |
| 3 | 5 |
Expected Output
| seller_name(VARCHAR) |
|---|
| BohoBob |
| CraftyChris |
Tags
EasyASKED IN INTERVIEWJoinsFilteringDate Handling
10-15 min
76%