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
- Git
- 편향-분산 교환
- sql
- 교차 엔트로피
- window function
- full request
- github
- L1정규화
- PYTHON
- 온라인협업
- 버전충돌
- merge
- conflict
- early stopping
- hackerrank
- HTML
- 선형 모형
- AWS
- programmers
- coding
- 코딩공부
- branch
- RLIKE
- elastic net
- leetcode
- CSS
- L2정규화
- 클라우드컴퓨팅
- 깃헙협업
- mysql
Archives
- Today
- Total
Im between cherry
Hackerrank | MySQL | Asian Population 본문
Asian Population
Asian Population | HackerRank
Query the sum of the populations of all cities on the continent 'Asia'.
www.hackerrank.com
Given the CITY and COUNTRY tables, query the sum of the populations of all cities where the CONTINENT is 'Asia'.
Note: CITY.CountryCode and COUNTRY.Code are matching key columns.
SELECT Sum(City.population)
FROM City
LEFT JOIN Country ON City.CountryCode = Country.Code
WHERE Country.Continent = 'Asia''데이터분석 > practice_query' 카테고리의 다른 글
| Hackerrank | MySQL | Average Population of Each Continent (0) | 2020.08.29 |
|---|---|
| Hackerrank | MySQL | African Cities (0) | 2020.08.29 |
| Hackerrank | MySQL | Weather Observation Station 17 (0) | 2020.08.29 |
| Hackerrank | MySQL | Weather Observation Station 16 (0) | 2020.08.29 |
| Hackerrank | MySQL | Weather Observation Station 15 (0) | 2020.08.29 |
Comments