Revising Aggregations - The Sum Function

AGGREGATION

Question Link

Query the total population of all cities in CITY where District is California.

Input Format

The CITY table is described as follows:

SELECT SUM(population)
FROM City
WHERE district = 'California'