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;

 

 

 

반응형

'HackerRank > SQL' 카테고리의 다른 글

[hackerrank] Top Earners  (0) 2022.08.31
[hackerrank] The Blunder  (0) 2022.08.25
[hackerrank] Japan Population  (0) 2022.08.24
[hackerrank] Average Population  (0) 2022.08.24
[hackerrank] Revising Aggregations - Averages  (0) 2022.08.24