We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
- Prepare
- SQL
- Basic Join
- African Cities
- Discussions
African Cities
African Cities
Sort by
recency
|
994 Discussions
|
Please Login in order to post a comment
SELECT CITY.NAME FROM CITY JOIN COUNTRY ON CITY.CountryCode = COUNTRY.Code WHERE CONTINENT = 'Africa'
SELECT C.NAME FROM CITY C JOIN COUNTRY CN ON C.CountryCode=CN.Code WHERE CN.CONTINENT = 'Africa';
SELECT CI.NAME FROM CITY AS CI JOIN COUNTRY AS CO ON CI.CountryCode = CO.Code WHERE CO.CONTINENT = "Africa";
mysql: select c.name from city c left join country co on c.countrycode = co.code where co.continent = 'Africa';