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: 

Solution Implementation


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

Leave a Reply

Your email address will not be published. Required fields are marked *