[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;

버림인지 반올림인지 잘 확인

 

(문제 출처 - https://www.hackerrank.com/domains/sql)