[해커랭크] African Cities

https://www.hackerrank.com/challenges/african-cities/problem?isFullScreen=true

African Cities | HackerRank

 

 

inner join 문제

city 테이블과 country 이블을

각각 a.countrycode = b.code 로 두는 문제

 

select a.name
from city A
inner join country B
on A.countrycode = B.code
where continent = 'Africa'