Patients in alphabetical order

Patients in alphabetical order

The registrar is preparing a printed patient directory. Return each patient's first and last name. Sort the list first by last name, then by first name, both in ascending order.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables. Your answer must use the same column names as this sample — alias them with AS if needed.

first_namelast_name
MaryBrooks
EveCarter
JohnDavis

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid