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';




codesadda.com

Codesadda.com is your home of programming solutions, tutorials, video tutorials and much more. Sign Up for our weekly newsletter to get update about new content.

Like us on Facebook | Connect with us on LinkedIn | Subscribe our Channel on Youtube