[SQL문제풀기] Average Population

문제

Average Population | HackerRank

Query the average population of all cities, rounded down to the nearest integer.

https://www.hackerrank.com/challenges/average-population/problem?isFullScreen=true

MySQL, Oracle, MS SQL Server, DB2

내가 작성한 정답

// MySQL, Oracle, DB2
select round(avg(population)) from city;

// MySQL, Oracle, MS SQL Server, DB2
select round(avg(population),0) from city;