Hackerrank - Population Census solution
Problem link
Solution one:
select sum(city.population) from city left join country on city.countrycode = country.code where continent = 'asia';
Problem link
select sum(city.population) from city left join country on city.countrycode = country.code where continent = 'asia';