[MySQL] Revising Aggregations - Averages

▶  SQL  >  Aggregation  > Revising Aggregations - Averages 

 Problem 

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'