Average Population of Each Continent

Description

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