Doctors in neurology wards

Doctors in neurology wards

The head of neurology is preparing a recognition list for colleagues who have handled at least one appointment in neurology wards. Include wards with the NEURO prefix. Return those doctors' last names without duplicates.

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.

last_name
Bennett
Carver
Hayes

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid