Display a list of doctors (doctor_id, doctor_name, specialty, selected_year, total_admissions) showing each doctor's ID, full name, specialty and total admissions for each year (Only include years that appear in the admissions table.). The list must contain all doctors, sorted by doctor_id and selected_year ascending.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Every doctor needs a row for every year, even the years with zero admissions.