MySQL > Revising Aggregations - Averages

Revising Aggregations - Averages
Query the average population of all cities in CITY where District is California.

Input Format

The CITY table is described as follows:

My Answer

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