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
- 교차 엔트로피
- 클라우드컴퓨팅
- coding
- hackerrank
- AWS
- window function
- merge
- PYTHON
- full request
- 선형 모형
- leetcode
- 버전충돌
- conflict
- programmers
- L2정규화
- L1정규화
- elastic net
- 온라인협업
- Git
- RLIKE
- 코딩공부
- github
- mysql
- 깃헙협업
- CSS
- early stopping
- 편향-분산 교환
- HTML
- sql
- branch
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