Customers From Austin
Whetcode Supply is trialling same-day delivery in Austin and wants to email the customers who could actually use it. Support needs the names and only the names — the mail tool takes a list of names and looks up the addresses itself, so anything extra in the result just has to be deleted again by hand.
One thing to be aware of: city is free text typed in at signup, stored exactly as the customer wrote it, capital A and all. SQL compares text exactly by default, so the value in the query has to match the value in the table character for character.
customers — one row per registered customer. city is the city given at signup, signup_date is an ISO date string.
| 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, listing every customer based in Austin, sorted alphabetically by name.
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