Find Your Solution Here

Hacker Rank, SQL

Average Population of Each Continent Hackerrank Solutions

Problem Link–https://www.hackerrank.com/challenges/average-population-of-each-continent/problem

Solution:

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

Leave a Reply