Hackerrank - Revising Aggregations - Averages solution

Solution one:

SELECT AVG(POPULATION) FROM CITY WHERE DISTRICT = "CALIFORNIA";