[해커랭크 SQL] Basic Join - African Cities

❓ Question
https://www.hackerrank.com/challenges/african-cities

African Cities | HackerRank

 

❗ Answer

SELECT city.name
    FROM city
    INNER JOIN country
            ON city.countrycode = country.code
    WHERE country.continent = 'Africa';

📌 Discussion

• join 후 조건에 해당하는 레코드만 추출