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

Population Density Difference

Sort 49 Discussions, By:

votes

  • bfdill + 4 comments

    SELECT MAX(Population) - MIN(Population) AS Joke FROM City;

    • akshat7 + 1 comment

      "AS Joke" xD :V

      • shashank347 + 0 comments

        haha :)

    • f_safari + 0 comments

      It is indeed a joke:D

    • manuelj + 0 comments

      upvoted for extra creativity :)

    • ravi122 + 0 comments

      hahahaha... hilarious :D

  • marinskiy + 0 comments

    Here is Oracle solution from my HackerrankPractice repository:

    SELECT MAX(Population) - MIN(Population)
FROM City;

    Feel free to ask if you have any questions :)

  • pedrokarneiro + 0 comments
    /*
This solution works for any of the listed RDBMSs:
DB2, mySQL, Oracle, SQL Server.
*/

SELECT MAX(population) - MIN(population)
FROM city;

  • prashantdhiman2 + 0 comments

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

  • abdelhameedkham1 + 0 comments

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

  • bartekbuda24 + 0 comments

    My solution: PRINT 4695354

  • aiswaryakv2595 + 0 comments

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

  • kezzetz + 0 comments

    select max(population)-min(population) from CITY

  • thaihoc081098 + 0 comments

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

  • tsvetoslav_tsve1 + 0 comments

    ORACLE:

    SELECT MAX(population) - MIN(population)
FROM city;
Load more conversations