Notice
Recent Posts
Recent Comments
Link
| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 1 | 2 | |||||
| 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| 10 | 11 | 12 | 13 | 14 | 15 | 16 |
| 17 | 18 | 19 | 20 | 21 | 22 | 23 |
| 24 | 25 | 26 | 27 | 28 | 29 | 30 |
| 31 |
Tags
- Semantic Segmentation
- 입문
- MySQL
- 큐
- pytorch
- Object Detection
- 알고리즘
- 파이썬
- 엘리스
- Recsys-KR
- 나는리뷰어다
- 스택
- Python
- DFS
- Image Segmentation
- 3줄 논문
- Machine Learning Advanced
- eda
- 추천시스템
- hackerrank
- DilatedNet
- Segmentation
- 코딩테스트
- 나는 리뷰어다
- 한빛미디어
- 튜토리얼
- 프로그래머스
- 협업필터링
- TEAM EDA
- TEAM-EDA
Archives
- Today
- Total
TEAM EDA
[HackerRank] Basic Join : Average Population of Each Continent 본문
Given the CITY and COUNTRY tables, query the names of all the continents (COUNTRY.Continent) and their respective average city populations (CITY.Population) rounded down to the nearest integer.
Note: CITY.CountryCode and COUNTRY.Code are matching key columns.
Input Format
The CITY and COUNTRY tables are described as follows:
풀이
SELECT O.CONTINENT, FLOOR(AVG(C.POPULATION))
FROM CITY AS C
JOIN COUNTRY AS O ON C.COUNTRYCODE = O.CODE
GROUP BY O.CONTINENT'EDA Study > SQL' 카테고리의 다른 글
| [HackerRank] Basic Join : Top Competitors (0) | 2021.02.08 |
|---|---|
| [HackerRank] Basic Join : The Report (2) | 2021.02.08 |
| [HackerRank] Basic Join : African Cities (0) | 2021.02.08 |
| [HackerRank] Basic Join : Asian Population (0) | 2021.02.08 |
| [HackerRank] Basic Select : Employee Salaries (0) | 2021.02.07 |
'EDA Study/SQL' Related Articles
more
