Average_population_of_each_continent.sql

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