<filename>SQL/Basic Join/Average Population of Each Continent/sol.sql
SELECT COUNTRY.CONTINENT,
    AVG(CITY.POPULATION)
FROM CITY
    INNER JOIN COUNTRY ON CITY.COUNTRYCODE = COUNTRY.CODE
GROUP BY COUNTRY.CONTINENT