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