Average Population of Each Continent.sql

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