[HackerRank/SQL] Revising Aggregations - Population Density Difference

Problem. Revising Aggregations - Population Density Difference

---

Link.

https://www.hackerrank.com/challenges/population-density-difference/problem?isFullScreen=true

Average Population | HackerRank

---

Description.

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

CITY 테이블

---

Key Point. 

SELECT,

 

AVG,

 

ROUND,

---

My Answer. 

SELECT MAX(POPULATION) - MIN(POPULATION)
FROM CITY;

---

References.