African Cities

Sort by

recency

|

992 Discussions

|

  • + 0 comments
    SELECT
        CITY.NAME
    FROM 
        CITY
    INNER JOIN
        COUNTRY
    ON 
        CITY.CountryCode = COUNTRY.Code
    WHERE
        COUNTRY.CONTINENT = 'Africa';
    
  • + 0 comments

    SELECT CI.NAME FROM CITY AS CI JOIN COUNTRY AS CO ON CI.CountryCode = CO.Code WHERE CO.CONTINENT = "Africa";

  • + 0 comments

    mysql: select c.name from city c left join country co on c.countrycode = co.code where co.continent = 'Africa';

  • + 0 comments

    EASY SOLUTION:

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

  • + 0 comments

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