[HackerRank SQL] African Cities

James Jung·2021년 7월 29일
0
post-thumbnail

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

Code link
https://github.com/JamesJung01/Hackerrank_sql/blob/main/01_Easy/Africa_cities.sql

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

0개의 댓글