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.
- Prepare
- SQL
- Aggregation
- Average Population
- Discussions
Average Population
Average Population
Sort by
recency
|
607 Discussions
|
Please Login in order to post a comment
SELECT FLOOR(AVG(POPULATION)) AS Average_Population FROM CITY;
mysql solution:-
select round(avg(population),0) as rounded from city ;
works even if you don't mention the zero!
select Round(avg(population)) from City ;
MY SQL
SELECT ROUND(AVG(POPULATION)) FROM CITY;
select round(ans,0) from (select avg(population) as ans from CITY);