African Cities Hackerrank Solution

 African Cities Hackerrank Solution 

Solution:

select city.name from city inner join country

on city.countrycode = country.code

where country.CONTINENT = 'Africa';