728x90
반응형
https://www.hackerrank.com/challenges/population-density-difference/problem?isFullScreen=true
Population Density Difference | HackerRank
Query the difference between the maximum and minimum city populations in CITY.
www.hackerrank.com
문제
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/bk74ba/btsrBogL96A/jGvT21KKkePysKREkZabxK/img.jpg)
Code
SELECT MAX(POPULATION) - MIN(POPULATION)
FROM CITY
728x90
반응형
'SQL > MySQL' 카테고리의 다른 글
[MySQL/HackerRank] Average Population of Each Continent (0) | 2023.08.21 |
---|---|
[MySQL/HackerRank] The Blunder (0) | 2023.08.21 |
[MySQL/HackerRank] Japan Population (0) | 2023.08.21 |
[MySQL/HackerRank] Average Population (0) | 2023.08.21 |
[MySQL/HackerRank] Revising Aggregations - Averages (0) | 2023.08.21 |