Query the difference between the maximum and minimum populations in CITY.
Input Format
The CITY table is described as follows:
![](https://blog.kakaocdn.net/dn/cGGJN3/btsI4SQ2E5h/5IFGrEXkcW7r2L8Um6bHx1/img.jpg)
SELECT
MAX(POPULATION) - MIN(POPULATION)
FROM
CITY
![](https://blog.kakaocdn.net/dn/bb8ley/btsI3egMFhE/y8rCh2B9d5eRudD44ggMKK/img.png)
'SQL > HackerRank' 카테고리의 다른 글
[MySQL/HackerRank] The Blunder (+ Ceil, Convert, Cast 함수) (0) | 2024.08.13 |
---|---|
[MySQL/HackerRank] Japan Population (0) | 2024.08.13 |
[MySQL/HackerRank] Average Population (0) | 2024.08.13 |
[MySQL/HackerRank] Revising Aggregations - Averages (0) | 2024.08.13 |
[MySQL/HackerRank] Revising Aggregations - The Sum Function (0) | 2024.08.13 |
Query the difference between the maximum and minimum populations in CITY.
Input Format
The CITY table is described as follows:
![](https://blog.kakaocdn.net/dn/cGGJN3/btsI4SQ2E5h/5IFGrEXkcW7r2L8Um6bHx1/img.jpg)
SELECT
MAX(POPULATION) - MIN(POPULATION)
FROM
CITY
![](https://blog.kakaocdn.net/dn/bb8ley/btsI3egMFhE/y8rCh2B9d5eRudD44ggMKK/img.png)
'SQL > HackerRank' 카테고리의 다른 글
[MySQL/HackerRank] The Blunder (+ Ceil, Convert, Cast 함수) (0) | 2024.08.13 |
---|---|
[MySQL/HackerRank] Japan Population (0) | 2024.08.13 |
[MySQL/HackerRank] Average Population (0) | 2024.08.13 |
[MySQL/HackerRank] Revising Aggregations - Averages (0) | 2024.08.13 |
[MySQL/HackerRank] Revising Aggregations - The Sum Function (0) | 2024.08.13 |