🏪 Empty Stalls Hurt the Marketplace.
The seller success team at Etsy flags any seller who has not made a single sale in the past 90 days as inactive — they need outreach before they churn completely.
Find all sellers with no sales in the last 90 days relative to 2024-04-30. Return seller_id, shop_name, and last_sale_date. Include sellers who have never sold at all.
sellers Table:
| Column | Type |
|---|---|
| seller_id | integer |
| shop_name | text |
| joined_date | text |
sales Table:
| Column | Type |
|---|---|
| sale_id | integer |
| seller_id | integer |
| amount | integer |
| sale_date | text |
Expected Outcome (Illustrative Sample):
| seller_id | shop_name | last_sale_date |
|---|---|---|
| 5 | SilkRoads | NULL |