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), 0)
FROM
CITY
'SQL > HackerRank' 카테고리의 다른 글
[MySQL/HackerRank] Population Density Difference (0) | 2024.08.13 |
---|---|
[MySQL/HackerRank] Japan Population (0) | 2024.08.13 |
[MySQL/HackerRank] Revising Aggregations - Averages (0) | 2024.08.13 |
[MySQL/HackerRank] Revising Aggregations - The Sum Function (0) | 2024.08.13 |
[MySQL/HackerRank] Revising Aggregations - The Count Function (0) | 2024.08.13 |