[HackerRank] [SQL] 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

실행 결과