문제
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))
From City
- City 테이블에서 모든 도시의 평균 반올림 (정수와 가장 가까운 수)
출처
반응형
'Algorithm > MySQL' 카테고리의 다른 글
[LeetCode] 620. Not Boring Movies (MySQL) (0) | 2021.07.05 |
---|---|
[LeetCode] 595. Big Countries (MySQL) (0) | 2021.07.05 |
[해커랭크(HackerRank)] Revising Aggregations - Averages (MySQL) (0) | 2021.07.04 |
[해커랭크(HackerRank)] Weather Observation Station 11 (MySQL) (0) | 2021.07.04 |
[해커랭크(HackerRank)] Weather Observation Station 10 (MySQL) (0) | 2021.07.04 |