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

|

681 Discussions

|

  • jatindhole187
     + 0 comments

    SELECT FLOOR(AVG(POPULATION)) from CITY

    here we have used the FLOOR() function in SQL is used to round a number down to the nearest integer.

  • govind3g21
     + 0 comments

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

  • abdullah_akcam52
     + 0 comments

    SELECT AVG(POPULATION) FROM CITY

  • yl2002
     + 0 comments

    select round(avg(population),0) from city;

  • dukavinod
     + 0 comments

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