Hackerrank - Revising Aggregations - The Sum Function solution

Solution one:

SELECT SUM(POPULATION) FROM CITY WHERE DISTRICT = "CALIFORNIA";