select ctr.continent, floor(avg(c.population)) as average_population from city c join country ctr on ctr.code = c.countrycode group by ctr.continent;