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