African Cities
- URL : https://www.hackerrank.com/challenges/african-cities/problem
- Given the CITY and COUNTRY tables, query the names of all cities where the CONTINENT is ‘Africa’.
- Note: CITY.CountryCode and COUNTRY.Code are matching key columns.
- Mysql solution
1
2
3
select city.name
from city, country
where countrycode = code and continent = 'africa';