Assume that no two provinces have cities with the same name. Display each city together with the total number of patients total_patients living in that city. Sort by the number of patients in descending order and in alphabetical order by city name.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Group by city, count the patients, and sort the counts from high to low.