Select CITY.NAME FROM CITY JOIN COUNTRY ON CITY.COUNTRYCODE = COUNTRY.CODE where COUNTRY.CONTINENT = 'Africa' ORDER BY COUNTRY.NAME, CITY.NAME;

This worked for me , i kept displaying the country.name too . so i errored a lot

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

select City.name from City Join Country on CITY.CountryCode = COUNTRY.Code where Country.Continent = 'Africa';

SELECT (CITY.NAME) FROM CITY INNER JOIN COUNTRY ON CITY.CountryCode = COUNTRY.Code WHERE CONTINENT="AFRICA";

MYSQL:-

select ci.name from city as ci inner join country as co on ci.CountryCode = co.Code where continent = 'Africa'