반응형
HackerRank Basic Join African Cities
SELECT CITY.NAME
FROM CITY
JOIN COUNTRY ON CITY.COUNTRYCODE = COUNTRY.CODE
WHERE COUNTRY.CONTINENT = 'Africa';
반응형
'코딩 테스트 > SQL' 카테고리의 다른 글
| HackerRank Population Census (0) | 2023.11.02 |
|---|---|
| HackerRank Basic Join Average Population of Each Continent (0) | 2023.11.01 |
| HackerRank Population Census (0) | 2023.10.30 |
| Weather Observation Station 12 (1) | 2023.10.29 |
| Weather Observation Station 11 (1) | 2023.10.28 |