728x90
반응형
https://www.hackerrank.com/challenges/average-population/problem?isFullScreen=true
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:

Code
SELECT ROUND(AVG(POPULATION))
FROM CITY
728x90
반응형
'SQL > MySQL' 카테고리의 다른 글
[MySQL/HackerRank] Population Density Difference (0) | 2023.08.21 |
---|---|
[MySQL/HackerRank] Japan Population (0) | 2023.08.21 |
[MySQL/HackerRank] Revising Aggregations - Averages (0) | 2023.08.21 |
[MySQL/HackerRank] Revising Aggregations - The Sum Function (0) | 2023.08.21 |
[MySQL/HackerRank] Revising Aggregations - The Count Function (0) | 2023.08.21 |