HackerRank MySQL - African Cities


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.

  1. SELECT CITY.NAME
  2. FROM CITY
  3. JOIN COUNTRY ON CITY.COUNTRYCODE = COUNTRY.CODE
  4. WHERE CONTINENT = 'Africa';

download android app