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
|
1032 Discussions
|
Please Login in order to post a comment
MySQL
SELECT ci.NAME FROM CITY ci JOIN COUNTRY co ON ci.COUNTRYCODE = co.CODE WHERE CONTINENT = 'Africa';
select c.name from city c join country co on c.countrycode = co.code where continent = 'Africa'
Select CITY.NAME FROM CITY JOIN COUNTRY ON CITY.COUNTRYCODE = COUNTRY.CODE where COUNTRY.CONTINENT = 'Africa' ORDER BY COUNTRY.NAME, CITY.NAME;
This worked for me , i kept displaying the country.name too . so i errored a lot
SELECT CI.NAME FROM CITY CI INNER JOIN COUNTRY CO ON CI.CountryCode = CO.Code WHERE CO.CONTINENT = 'Africa';
select City.name from City Join Country on CITY.CountryCode = COUNTRY.Code where Country.Continent = 'Africa';