문제
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출처
반응형
'Algorithm > MySQL' 카테고리의 다른 글
| [해커랭크(Hacker Rank)] Weather Observation Station 4 (MySQL) (0) | 2021.06.30 |
|---|---|
| [해커랭크(Hacker Rank)]Population Density Difference (MySQL) (0) | 2021.06.30 |
| [해커랭크(Hacker Rank)]Revising Aggregations - The Count Function (MySQL) (0) | 2021.06.30 |
| [해커랭크(Hacker Rank)] Revising Aggregations - The Sum Function (MySQL) (0) | 2021.06.30 |
| [해커랭크(Hacker Rank)] Revising Aggregations - Averages (MySQL) (0) | 2021.06.30 |