문제
Query the difference between the maximum and minimum populations in CITY.
Input Format
The CITY table is described as follows:
코드
SELECT MAX(population) - MIN(population)
FROM city풀이
1. population의 최댓값과 최소값 빼기
출처
반응형
'Algorithm > MySQL' 카테고리의 다른 글
| [해커랭크(Hacker Rank)] Top Earners (MySQL) (0) | 2021.06.30 |
|---|---|
| [해커랭크(Hacker Rank)] Weather Observation Station 4 (MySQL) (0) | 2021.06.30 |
| [해커랭크(Hacker Rank)]Average Population (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 |