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.
  1. Prepare
  2. SQL
  3. Aggregation
  4. Population Density Difference
  5. Discussions

Population Density Difference

Sort by

recency

|

549 Discussions

|

  • hernan_perezhig1
     + 0 comments
    SELECT 
    MAX(POPULATION) - MIN(POPULATION) AS Population_difference
FROM CITY

  • bhavyg12911
     + 0 comments

    SELECT max(population)-min(population) FROM city;

    solution query

  • ankitagaganmali1
     + 0 comments

    ** MYSQL**

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

  • sharudinluthfil
     + 0 comments

    As amateur, i wrote it like this

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

    It still works and i don't understand why need to put "AS Difference". is that a comment or a new command?

  • krrajeev00000001
     + 0 comments

    select (max(POPULATION) - min(POPULATION)) as Population_diff from city;