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