|| Excellence in Every Line of Code

Average Population

Query the average population for all cities in CITY, rounded down to the nearest integer.

Input Format

The CITY table is described as follows:

Solution Implementation


SELECT FLOOR(AVG(POPULATION))
FROM CITY;

Copied!