Show how many admissions each doctor (doctor_id, first_name, last_name) has handled (total_admissions). Only show doctors with 2 or more admissions. Sort by each doctor's total_admissions in descending order, then 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
Group admissions by doctor, then filter the groups with HAVING rather than WHERE.