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
|
1054 Discussions
|
Please Login in order to post a comment
SELECT CITY.NAME FROM CITY INNER JOIN COUNTRY ON CITY.COUNTRYCODE = COUNTRY.CODE WHERE COUNTRY.CONTINENT = 'Africa';
MYSql
SELECT CITY.NAME FROM CITY INNER JOIN COUNTRY ON CITY.COUNTRYCODE = COUNTRY.CODE WHERE COUNTRY.CONTINENT = 'Africa';
select distinct a.NAME from CITY as a LEFT JOIN COUNTRY as b on a.COUNTRYCODE = b.CODE where b.CONTINENT = 'Africa';
SELECT C.NAME FROM CITY C LEFT JOIN COUNTRY O ON C.COUNTRYCODE=O.CODE WHERE O.CONTINENT='Africa';