[Oracle] Basic Join : African Cities

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

African Cities | HackerRank

 

 

---

문제

-> City 테이블과 Country 테이블에서 Continent가 Africa인 모든 도시의 이름을 출력하라.

 

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

 

---