mssql

SELECT SUM(cty.population) 
FROM CITY cty WITH (NOLOCK)
INNER JOIN COUNTRY ctry WITH (NOLOCK) 
ON cty.COUNTRYCODE = ctry.CODE
WHERE ctry.CONTINENT = 'ASIA'
GROUP BY ctry.CONTINENT