[HackerRank/Basic Join] African Cities

https://www.hackerrank.com/challenges/african-cities/problem 

African Cities | HackerRank

 

문제

 

풀이

 

SELECT CITY.NAME FROM CITY
INNER JOIN COUNTRY
ON CITY.COUNTRYCODE = COUNTRY.CODE
WHERE COUNTRY.CONTINENT = 'Africa'