All problems

Customers From Austin

easySQLFiltering

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

Discussion

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

Loading comments…