Average Population | HackerRank
Query the average population of all cities, rounded down to the nearest integer.
www.hackerrank.com
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 |
