[HackerRank][SQL][JOIN] African Cities- 컴도리돌이

African Cities | HackerRank

---

Problem

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.

 

-> 아프리카 대륙에 있는 모든 도시의 이름을 출력하시오.

---

Answer

select a.name
from city a inner join country b on a.countrycode = b.code
where b.continent = "Africa"