african-cities.mysql.sql

-- https://www.hackerrank.com/challenges/african-cities/problem
-- African Cities

select distinct city.name
from city 
inner join country on city.countrycode = country.code
where country.continent = 'Africa'