HackerRank/SQL

[hackerrank] Population Density Difference

예쁜꽃이피었으면 2022. 8. 24. 10:03

[hackerrank] Prepare > SQL > Aggregation > Population Density Difference

 

[문제]

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

Input Format

The CITY table is described as follows: 

 

[MYSQL]

 

 

[ORCALE]

select max(population)-min(population)
from city;

 

 

 

반응형