Retrieve all doctors (doctor_id, full_name, specialty), where full_name is last_name and first_name joined by a comma (without spaces), with last_name fully in uppercase and first_name fully in lowercase, sorted by the doctor_id part in ascending order. The column names and order must match the expected output.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Apply a case function to each name part before joining them with a comma.