African Cities --- Joins and Unions-1

SESSION NAME: Joins and Unions-1.

QUESTION NAME: African Cities.

TABLE DESCRIPTION:

Given the CITY and COUNTRY tables, query the names of all
cities where the CONTINENT is Africa.

Note: CITY.CountryCode and COUNTRY.Code are
matching key columns.

CODE:

select CITY.NAME from CITY join COUNTRY on COUNTRY.Code = CITY.CountryCode where COUNTRY.Continent = 'Africa';