Customers who already ordered something
Marketing wants to split the base into those who hit «checkout» at least once (even if they later cancelled) and those who only signed up. Return the id and name of customers with at least one order — status doesn't matter. 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 |
|---|---|
| 1 | Аня |
| 2 | Боб |
| 3 | Вера |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid