Delhi Customers or Silent Buyers
MediumDescription
Marketing wants one list of customer_ids, each once, made of:
- every customer who lives in Delhi, whether or not they reviewed
- every customer who has placed an order but has never written a review
End your query with ORDER BY customer_id.
Tables
| customers |
|---|
| customer_id (PK) |
| city |
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| reviews |
|---|
| review_id (PK) |
| customer_id (FK) |