Asian Population | SQL

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(City.POPULATION) from Country INNER JOIN CITY ON City.CountryCode=Country.Code where Continent='Asia';

Add a Comment

Your email address will not be published. Required fields are marked *