List population of provices (SQL Query)
You need to include the aggregate operation to get the sum of population.  So:

SELECT Province, SUM(Population) AS PopulationSum FROM CANADA GROUP BY Province


In english it would be, I want the sum of the population column, by province from the Canada table.