African Cities

Sort by

recency

|

987 Discussions

|

  • + 0 comments

    SELECT CITY.NAME AS NAME_CITY FROM CITY JOIN COUNTRY ON CITY.COUNTRYCODE = COUNTRY.CODE WHERE COUNTRY.CONTINENT = 'Africa';

  • + 0 comments

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

  • + 0 comments

    For MySQL

    SELECT city.name FROM city
    JOIN country ON city.countrycode = country.code
    WHERE country.continent = "africa";
    
  • + 0 comments
    SELECT ct.NAME
    FROM CITY ct JOIN COUNTRY cnt 
    ON ct.COUNTRYCODE = cnt.CODE
    WHERE cnt.CONTINENT = 'Africa';
    
  • + 0 comments

    SELECT CITY.NAME FROM CITY WHERE CITY.COUNTRYCODE IN (SELECT COUNTRY.CODE FROM COUNTRY WHERE COUNTRY.CONTINENT = 'Africa')