Algorithm/SQL

[SQL][HackerRank] Population Density Difference

융무 2020. 6. 11. 14:48

https://www.hackerrank.com/challenges/population-density-difference/problem?h_r=next-challenge&h_v=zen

 

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:

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