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;
'Algorithm > SQL' 카테고리의 다른 글
[SQL][HackerRank] Top Earners (0) | 2020.06.12 |
---|---|
[SQL][HackerRank] Population Density Difference (0) | 2020.06.11 |
[SQL][HackerRank] Higher Than 75 Marks (0) | 2020.06.11 |
[SQL][HackerRank] Average Population (0) | 2020.06.11 |
[SQL][HackerRank] Revising Aggregations - Averages (0) | 2020.06.11 |