🤔 문제 분석
1) Query the average population for all cities in CITY, rounded down to the nearest integer.
💡 풀이
SELECT ROUND(AVG(POPULATION), 0)
FROM CITY
'코딩테스트 > 해커랭크 SQL' 카테고리의 다른 글
| [해커랭크/SQL] 27. Population Density Difference (0) | 2023.03.07 |
|---|---|
| [해커랭크/SQL] 26. Japan Population (0) | 2023.03.07 |
| [해커랭크/SQL] 24. Revising Aggregations - Averages (0) | 2023.03.06 |
| [해커랭크/SQL] 23. Revising Aggregations - The Sum Function (0) | 2023.03.06 |
| [해커랭크/SQL] 22. Revising Aggregations - The Count Function (0) | 2023.03.06 |
댓글