반응형
HackerRank Basic Join Average Population of Each Continent
SELECT COUNTRY.CONTINENT, FLOOR(AVG(CITY.POPULATION))
FROM CITY
JOIN COUNTRY ON CITY.COUNTRYCODE = COUNTRY.CODE
GROUP BY COUNTRY.CONTINENT;
반응형
'코딩 테스트 > SQL' 카테고리의 다른 글
| HackerRank Population Census (0) | 2023.11.02 |
|---|---|
| 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 |