All problems

Who's in Our Austin Market?

easySQLFiltering

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

Discussion

Sign in to join the discussion — reading is open to everyone.

Loading comments…