We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Population Density Difference
Population Density Difference
Sort by
recency
|
507 Discussions
|
Please Login in order to post a comment
SELECT MAX(POPULATION) - MIN(POPULATION) FROM CITY;
--difference between the maximum and minimum populations in CITY
WITH CTE AS ( SELECT MAX(POPULATION) AS MAX_POPULATION, MIN(POPULATION) AS MIN_POPULATION FROM CITY ) SELECT MAX_POPULATION - MIN_POPULATION FROM CTE;
select max(population) - min(population) from city
For MySQL
SELECT MAX(population)-MIN(population) FROM CITY