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
|
1028 Discussions
|
Please Login in order to post a comment
select City.name from City Join Country on CITY.CountryCode = COUNTRY.Code where Country.Continent = 'Africa';
SELECT (CITY.NAME) FROM CITY INNER JOIN COUNTRY ON CITY.CountryCode = COUNTRY.Code WHERE CONTINENT="AFRICA";
MYSQL:-
select ci.name from city as ci inner join country as co on ci.CountryCode = co.Code where continent = 'Africa'
for mysql
SELECT CITY.NAME FROM CITY JOIN COUNTRY ON CITY.COUNTRYCODE = COUNTRY.CODE WHERE COUNTRY.CONTINENT='Africa'
SELECT C.NAME FROM CITY C INNER JOIN COUNTRY CN ON C.COUNTRYCODE=CN.CODE WHERE CN.CONTINENT="AFRICA";