Who's in Our Austin Market?
Whetcode Supply is trialling same-day delivery in a single city before committing to it, and Austin has been chosen for the pilot. Marketing needs the names of the customers who live there so the announcement email goes only to people who can actually use it.
Each customer row records exactly one city as plain text, so this is a question about which rows belong on the list rather than about combining anything. The email is addressed by name, so the name is the only column that needs to come back.
customers — one row per registered customer. city is the city they gave at signup.
| id | name | city | signup_date |
|---|---|---|---|
| 1 | Priya Nair | Austin | 2022-01-15 |
| 2 | Tom Becker | Berlin | 2022-03-02 |
| 3 | Sofia Rossi | Milan | 2022-05-19 |
| 4 | Liam OConnor | Dublin | 2023-01-08 |
| 5 | Wei Zhang | Austin | 2023-04-27 |
The table already exists in the database — there is nothing to create or load.
Task: Write a query returning a single column, name, for every customer based in Austin, in alphabetical name sequence.
Example output — shape only, on invented names.
| name |
|---|
| Dana Reyes |
| Ola Berg |
Sign in to solve this problem
Reading problems is free for everyone — solving them (Run, Submit, and tracking what you've solved) needs an account.
Sign in