Hackerrank - Revising Aggregations - The Sum Function solution

Problem link

Solution one:

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