[HakerRank / MySQL] African Cities

 

https://www.hackerrank.com/challenges/african-cities/problem?isFullScreen=true

African Cities | HackerRank

 

 

 

SELECT city.name
FROM city
    INNER JOIN country ON city.countrycode = country.code
WHERE country.continent = 'Africa'