SQL 문제풀이

[해커랭크 SQL] Aggregation - Population Density Difference

냄비짱 2023. 8. 23. 00:25
728x90

❓ Question
https://www.hackerrank.com/challenges/population-density-difference

 

Population Density Difference | HackerRank

Query the difference between the maximum and minimum city populations in CITY.

www.hackerrank.com

❗ Answer

SELECT MAX(population) - MIN(population)
    FROM city;

📌 Discussion

  • max - min으로 최댓값 - 최솟값 추출