Hackerrank - Population Census solution

Solution one:

select sum(city.population) from city left join country on city.countrycode = country.code where continent = 'asia';