728x90
❓ Question
https://www.hackerrank.com/challenges/population-density-difference
❗ Answer
SELECT MAX(population) - MIN(population)
FROM city;
📌 Discussion
- max - min으로 최댓값 - 최솟값 추출
'SQL 문제풀이' 카테고리의 다른 글
[해커랭크 SQL] Aggregation - Revising Aggregations - The Count Function (0) | 2023.08.25 |
---|---|
[해커랭크 SQL] Aggregation - The Blunder (0) | 2023.08.23 |
[해커랭크 SQL] Aggregation - Japan Population (0) | 2023.08.23 |
[해커랭크 SQL] Aggregation - Average Population (0) | 2023.08.23 |
[해커랭크 SQL] Aggregation - Revising Aggregations - Averages (0) | 2023.08.23 |