You are viewing a single comment's thread. Return to all comments →
SELECT SUM(POPULATION) FROM CITY WHERE COUNTRYCODE IN (SELECT CODE FROM COUNTRY WHERE CONTINENT = 'Asia');
____________________OR______________________________
SELECT SUM(CI.POPULATION) FROM CITY AS CI INNER JOIN COUNTRY AS CO ON CI.COUNTRYCODE = CO.CODE WHERE CO.CONTINENT = 'Asia';
Seems like cookies are disabled on this browser, please enable them to open this website
Population Census
You are viewing a single comment's thread. Return to all comments →
SELECT SUM(POPULATION) FROM CITY WHERE COUNTRYCODE IN (SELECT CODE FROM COUNTRY WHERE CONTINENT = 'Asia');
____________________OR______________________________
SELECT SUM(CI.POPULATION) FROM CITY AS CI INNER JOIN COUNTRY AS CO ON CI.COUNTRYCODE = CO.CODE WHERE CO.CONTINENT = 'Asia';