Hackerrank - Revising Aggregations - Averages solution

Problem link

Solution one:

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