SQL join

select c,floor(avg(p)) from (
select A.population as p,B.continent as c from city A
inner join country  B
on A.countrycode =  B.code
     )
group by c;