Find the doctors (doctor_name (full_name), specialty, total_admissions) whose total admissions are higher than the average number of admissions of all doctors in the same specialty (doctors with no admissions are not counted). Sort by total_admissions in descending order.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Now the average is calculated within each specialty, and doctors without admissions are excluded.