We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
- Prepare
- SQL
- Basic Join
- Population Census
- Discussions
Population Census
Population Census
Sort by
recency
|
1500 Discussions
|
Please Login in order to post a comment
select sum(city.population) from city join country on city.contrycode = country.code where country.continent = 'Asia';
MS SQL Server
SELECT SUM(cc.population) FROM country c INNER JOIN city cc ON c.code= cc.countrycode WHERE continent ="Asia";
select sum(ci.population) from city ci join country co on ci.countrycode=co.code where co.continent="asia";
My answer: