Who's in Our Miami Market?

Northline Bank is opening a branch in Miami and the team preparing the launch wants to see who the bank already has in that city, and what kind of account each of them holds — savings customers and current-account customers get different welcome letters.

Each customer row records exactly one city and exactly one account type, both as plain text, so nothing has to be combined or counted. The only decisions are which rows belong on the list and which two columns the letters need.

customers — one row per account holder. account_type is checking or savings. city is the branch city they are registered at.

The table already exists in the database — there is nothing to create or load.

Task: Write a query returning two columns, name and account_type, for every customer registered in Miami, in alphabetical name sequence.

Example output — shape only, on invented customers.