Discussion on Average Population of Each Continent Challenge

2 weeks ago+ 0 comments

select
    cnt.continent,
    round(avg(ct.population),0)
from
    city ct
join country cnt on cnt.code = ct.countrycode
group by cnt.continent;