Find the doctors (doctor_id, doctor_name (full name), specialty, total_admissions) whose total admissions are higher than the average number of admissions across all doctors (doctors with no admissions are counted in the average). Sort by total_admissions in descending order, in the event of a tie in total_admissions, filter by doctor_id in ascending order.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Compare each doctor's total with the average total, and count doctors with no admissions too.