African Cities

  • + 0 comments
    SELECT ci.name
    FROM city ci
    JOIN country co ON ci.countrycode = co.code
    WHERE co.continent = 'Africa';