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. Average Population
  5. Discussions

Average Population

Sort by

recency

|

675 Discussions

|

  • shreyanshsaurav1
     + 0 comments

    SELECT FLOOR(AVG(POPULATION)) AS AVG_POPULATION FROM CITY;

  • shivarajesh91
     + 0 comments

    mysql:

    select round(avg(population)) from city;

  • sonianshul1982
     + 1 comment

    SELECT ROUND(AVG(POPULATION), 0) FROM CITY; OR SELECT FLOOR(AVG(POPULATION)) FROM CITY;

    both works fine

  • nikhildoppani9
     + 0 comments
    SELECT ROUND(AVG(POPULATION)) FROM CITY;

  • lokeshjai902
     + 0 comments

    for ms sql SELECT CEILING(AVG(POPULATION)) FROM CITY