Display (full_name, height) of the patients with the highest and lowest height. full_name is first_name concatenated with last_name. Sort by height ascending and do not show rows where heightis NULL. If two patients have the same height, sort by full_name alphabetically.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
You need both the tallest and the shortest patients, and ties count. Ranking helps, and NULL heights need special care.