Customers who never placed an order
Marketing is preparing a promo email for «dormant» customers — those who registered but never placed a single order (cancelled ones don't count either). Return the id and name of such customers, sort by id.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| id | name |
|---|---|
| 7 | Миша |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid