Display the province name (province_name), the name of each city in that province, and the total number of patients total_patients living in each city. Sort by the number of patients in descending order and in alphabetical order by province, city name.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Group by province and city together, because a city name alone can repeat across provinces.