[HackerRank] Average Population of Each Continent

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT CO.Continent
     , FLOOR(AVG(C.Population))
FROM CITY AS C
    INNER JOIN COUNTRY AS CO ON C.CountryCode = CO.Code
GROUP BY CO.Continent