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