[HackerRank] Average Population of Each Continent

 

SELECT COUNTRY.Continent
     , FLOOR(AVG(CITY.population))
FROM CITY
     INNER JOIN COUNTRY ON CITY.CountryCode = COUNTRY.CODE
GROUP BY COUNTRY.Continent