African Cities

Sort by

recency

|

1028 Discussions

|

  • + 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 INNER JOIN COUNTRY ON CITY.CountryCode = COUNTRY.Code WHERE CONTINENT="AFRICA";

  • + 0 comments

    MYSQL:-

    select ci.name from city as ci inner join country as co on ci.CountryCode = co.Code where 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 C.NAME FROM CITY C INNER JOIN COUNTRY CN ON C.COUNTRYCODE=CN.CODE WHERE CN.CONTINENT="AFRICA";