Average Population of Each Continent

  • + 0 comments

    MS Sql -

    select c.continent , round(avg(ci.population),2) from country c inner join city ci on c.code = ci.countrycode group by c.continent;