Hackerrank - African Cities solution
Problem link
Solution one:
select city.name from city left join country on city.countrycode = country.code where continent = 'africa';
Problem link
select city.name from city left join country on city.countrycode = country.code where continent = 'africa';