|
1
2
3
4
|
select country.continent, truncate (avg(city.population),0)
from city
join country on city.countrycode=country.code
group by country.continent
|
cs |
반응형
'SQL' 카테고리의 다른 글
| leetcode 595. Big Countries (0) | 2022.03.17 |
|---|---|
| Hacker rank Type of Triangle (0) | 2021.10.23 |
| Hacker rank Weather Observation Station 17 (0) | 2021.10.21 |
| Hacker rank Weather Observation Station 16 (0) | 2021.10.21 |
| Hacker rank Weather Observation Station 15 (0) | 2021.10.21 |
댓글