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
'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 |