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