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

|

677 Discussions

|

  • dukavinod
     + 0 comments

    select cast(avg(population) as decimal(10,0)) from city

  • SVVBathini
     + 0 comments

    For MySQL

    SELECT ROUND(AVG(population)) FROM city;

  • shreyanshsaurav1
     + 1 comment

    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