📌[SQL 문제 풀이] 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
;