[HackerRank] African Cities

SELECT CITY.NAME
FROM CITY
     INNER JOIN COUNTRY ON CITY.CountryCode = COUNTRY.Code
WHERE COUNTRY.CONTINENT = 'Africa'