Given the CITY
and COUNTRY
tables, query the sum of the populations of all cities where the CONTINENT is 'Asia'.
Note
: CITY.CountryCode and COUNTRY.Code are matching key columns.
Input Format
The CITY
and COUNTRY
tables are described as follows:
SELECT SUM(A.POPULATION)
FROM CITY AS A INNER JOIN COUNTRY AS B
ON A.COUNTRYCODE = B.CODE
WHERE B.CONTINENT = 'Asia';