본문 바로가기
SQL

Hacker rank Average Population of Each Continen

by 무적김두칠 2021. 10. 23.

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

댓글