HackerRank-Aggregation-Average Population - floor

Average Population - floor

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

Input Format The CITY table is described as follows:

My solution

SELECT FLOOR(AVG(population))
FROM CITY;