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 54 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

  • _clfm_ + 0 comments

    MySQL - clean & correct

    Let me know if you have any questions!

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

    (From my HackerRank repo on GitHub.)

  • wuyulin_212 + 0 comments

    ms sql server

    select name from students where marks >75 order by right(name,3),ID ;

  • pankajjoshi870_1 + 0 comments

    select (select population from city order by population desc limit 1)- (select population from city order by population asc limit 1);

  • pralabhsaxena05 + 0 comments

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

  • nizamcse_seu + 0 comments

    FOR ORACLE

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

  • abdelhameedkham1 + 0 comments

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

Load more conversations