SELECT
    SUM(a.POPULATION)
FROM
    CITY AS a
    LEFT JOIN COUNTRY AS b
    ON UPPER(a.COUNTRYCODE) = UPPER(b.CODE)
WHERE
    b.CONTINENT = 'Asia'