You are viewing a single comment's thread. Return to all comments →
select sum(a.population) as total_population from city a join country b on a.countrycode = b.code where b.continent = 'Asia';
Seems like cookies are disabled on this browser, please enable them to open this website
I agree to HackerRank's Terms of Service and Privacy Policy.
Population Census
You are viewing a single comment's thread. Return to all comments →
select sum(a.population) as total_population from city a join country b on a.countrycode = b.code where b.continent = 'Asia';