Revising Aggregations - Averages

AGGREGATION

Question Link

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

Input Format

The CITY table is described as follows:

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