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
|
737 Discussions
|
Please Login in order to post a comment
SELECT round(avg(population)) FROM city;
Easy solution
select floor(avg(POPULATION)) as average_population_per_city from CITY;
SELECT FLOOR(AVG(Population)) AS average_population FROM CITY;
select round(avg(population)) from city;
MYSQL