Average Population:- HackerRank Solution in MYSQL

Problem:-

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:-

SELECT ROUND(AVG(POPULATION),0)

FROM CITY