Display each province name province_name with the total number of patients total_patients living in that province total_patients. Sort by the number of patients in descending order and in alphabetical order by province name.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Some provinces may have no patients at all. Which kind of join keeps them?