Average-Population-of-Each-Continent.sql

SELECT c2.CONTINENT, FLOOR(AVG(c1.POPULATION)) FROM COUNTRY c2 
INNER JOIN CITY c1 
WHERE c1.COUNTRYCODE = c2.CODE
GROUP BY c2.CONTINENT;