African Cities

Sort by

recency

|

980 Discussions

|

  • + 0 comments

    select CITY.name from city as CITY INNER JOIN COUNTRY ON CITY.CountryCode = COUNTRY.Code where Country.continent = 'Africa';

  • + 0 comments

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

  • + 0 comments
    select city.name
    from city, country
    where country.continent = 'Africa'
    and city.countrycode = country.code
    
  • + 0 comments
    SELECT
        C.Name
    FROM
        City C
    INNER JOIN
        Country Cn ON C.CountryCode = Cn.Code
    WHERE
        Cn.Continent = 'Africa'
    
  • + 0 comments

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