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
|
1015 Discussions
|
Please Login in order to post a comment
SELECT DISTINCT C.NAME FROM CITY C INNER JOIN COUNTRY T ON C.COUNTRYCODE = T.CODE WHERE CONTINENT = 'AFRICA'
SELECT NAME, COUNTRYCODE FROM CITY WHERE COUNTRYCODE IN ( SELECT CODE FROM COUNTRY WHERE CONTINENT = 'Africa' );
SELECT CITY.Name FROM CITY JOIN COUNTRY ON CITY.CountryCode = COUNTRY.Code WHERE COUNTRY.Continent = 'Africa';