Population Census

  • + 0 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';