Prepare > SQL > Aggregation > Population Density Difference
2023. 5. 16. 20:38ㆍHackerRank-My SQL
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.
코드
SELECT MAX(POPULATION) - MIN(POPULATION) FROM CITY;
두 번째 시도
SELECT MAX(POPULATION) - MIN(POPULATION) FROM CITY;- 똑같음
'HackerRank-My SQL' 카테고리의 다른 글
| Prepare> SQL > Aggregation > Revising Aggregations - The Count Function (0) | 2023.05.16 |
|---|---|
| Prepare > SQL > Aggregation > The Blunder (0) | 2023.05.16 |
| Prepare > SQL > Aggregation > Japan Population (0) | 2023.05.16 |
| Prepare > SQL > Aggregation > Average Population (0) | 2023.05.16 |
| Prepare > SQL > Advanced Select > Occupations (3) | 2023.05.16 |