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
|
1519 Discussions
|
Please Login in order to post a comment
SELECT SUM(CITY.POPULATION) FROM COUNTRY JOIN CITY ON CITY.COUNTRYCODE = COUNTRY.CODE WHERE COUNTRY.CONTINENT = 'Asia';
SELECT SUM(CITY.POPULATION) FROM CITY INNER JOIN COUNTRY ON CITY.COUNTRYCODE = COUNTRY.CODE WHERE COUNTRY.CONTINENT = "Asia";
MYSql
SELECT SUM(CITY.POPULATION) FROM CITY INNER JOIN COUNTRY ON CITY.COUNTRYCODE = COUNTRY.CODE WHERE COUNTRY.CONTINENT = 'Asia';
select sum(a.POPULATION) from CITY as a LEFT JOIN COUNTRY as b ON a.COUNTRYCODE = b.CODE where b.CONTINENT = 'Asia';