African Cities

Sort by

recency

|

1015 Discussions

|

  • + 0 comments
    SELECT CITY.NAME 
    FROM CITY JOIN COUNTRY 
    ON CITY.COUNTRYCODE = COUNTRY.CODE 
    WHERE CONTINENT = 'Africa';
    
  • + 0 comments

    SELECT DISTINCT C.NAME FROM CITY C INNER JOIN COUNTRY T ON C.COUNTRYCODE = T.CODE WHERE CONTINENT = 'AFRICA'

  • + 0 comments

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

  • + 0 comments

    SELECT CITY.Name FROM CITY JOIN COUNTRY ON CITY.CountryCode = COUNTRY.Code WHERE COUNTRY.Continent = 'Africa';

  • + 0 comments
    SELECT city.name
    FROM city JOIN country
    ON country.code = city.countrycode
    WHERE CONTINENT like 'Africa'
    ;