Sol 1: (with help of comma-separated join)

select city.name from city,country where country.continent='Africa' and city.countrycode=country.code;

Sol 2: (with JOIN)

Select city.name from city join country on city.countrycode=country.code where country.continent = 'Africa';