|| Excellence in Every Line of Code

Revising Aggregations – The Sum Function

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

Input Format

The CITY table is described as follows:

Solution Implementation


SELECT SUM(POPULATION)
FROM CITY
WHERE DISTRICT = 'California';

Copied!