SESSION NAME: Joins and Unions-1.

QUESTION NAME: Asian Population.


TABLE DESCRIPTION:
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.

CODE:
select SUM(CITY.POPULATION) from CITY join COUNTRY on 
COUNTRY.Code =  CITY.CountryCode where COUNTRY.Continent = 'Asia';