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