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