Problem:-
Solution:-
select max(population)-min(population)
from city
Query the difference between the maximum and minimum populations in CITY.
Input Format
The CITY table is described as follows: ![CITY.jpg](https://s3.amazonaws.com/hr-challenge-images/8137/1449729804-f21d187d0f-CITY.jpg)
![CITY.jpg](https://s3.amazonaws.com/hr-challenge-images/8137/1449729804-f21d187d0f-CITY.jpg)
Solution:-
select max(population)-min(population)
from city
No comments:
Post a Comment