Revising Aggregations - Averages:- HackerRank Solution in MYSQL

Problem:-

Query the average population of all cities in CITY where District is California.

Input Format

The CITY table is described as follows:

Solution:-


SELECT AVG(Population)
FROM City

WHERE District = 'California';