Display (first_name, last_name, role) for every person, with role 'Patient' for patients and 'Doctor' for doctors. The displayed results are sorted alphabetically by first_name and last_name. Column names and the column order must match the expected output exactly.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Stack two result sets that have the same columns, and add a constant label to each one.