문제 link
https://www.hackerrank.com/challenges/african-cities/problem
Code link
https://github.com/JamesJung01/Hackerrank_sql/blob/main/01_Easy/Africa_cities.sql
SELECT CITY.NAME FROM CITY JOIN COUNTRY ON CITY.COUNTRYCODE = COUNTRY.CODE WHERE COUNTRY.CONTINENT = 'Africa';