HackerRank-Aggregation-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 solution

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