[MySQL실습] 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

• CEIL() : 올림
• FLOOR() : 버림
• ROUNT() : 반올림