[MySQL/HackerRank] 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: 

 

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

 

HackerRank MySQL EASY