| 일 | 월 | 화 | 수 | 목 | 금 | 토 |
|---|---|---|---|---|---|---|
| 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 |
Tags
- algorithm
- kakao
- Heap
- DeepLearning
- SQL
- dl
- Word2vec
- CBOW
- 자연어처리
- boj
- que
- Stack
- stak
- hash
- FullyConnectedLayer
- select
- PPMI
- Numpy
- Sigmoid
- sort
- 신경망
- affine
- 파이썬
- MySQL
- skip-gram
- backward
- Python
- 프로그래머스
- Programmers
- 딥러닝
Archives
- Today
- Total
혜온의 이것저것
[HackerRank] Japan Population (MySQL) 본문
Japan Population | HackerRank
Query to the sum of the populations of all Japanese cities in CITY.
www.hackerrank.com
문제
Query the sum of the populations for all Japanese cities in CITY. The COUNTRYCODE for Japan is JPN.
Input Format
The CITY table is described as follows:
풀이
select sum(population)
from city
where countrycode='JPN''Data Analysis > SQL' 카테고리의 다른 글
| [HackerRank] The Blunder (MySQL) (0) | 2022.08.15 |
|---|---|
| [HackerRank] Population Density Difference (MySQL) (0) | 2022.08.15 |
| [HackerRank] Average Population (0) | 2022.08.12 |
| [HackerRank] Revising Aggregations- Averages (MySQL) (0) | 2022.08.12 |
| [HackerRank] Revising Aggregations- The Sum Function (MySQL) (0) | 2022.08.12 |
'Data Analysis/SQL' Related Articles
more
Comments