Query the average population for all cities in CITY, rounded down to the nearest integer.
Input Format
The CITY table is described as follows:
SELECT ROUND(AVG(POPULATION))
FROM CITY;
'Algorithm > SQL' 카테고리의 다른 글
[SQL][HackerRank] Population Density Difference (0) | 2020.06.11 |
---|---|
[SQL][HackerRank] Higher Than 75 Marks (0) | 2020.06.11 |
[SQL][HackerRank] Revising Aggregations - Averages (0) | 2020.06.11 |
[SQL][HackerRank] Revising Aggregations - The Sum Function (0) | 2020.06.11 |
[SQL][HackerRank] Revising Aggregations - The Count Function (0) | 2020.06.11 |