Milky's note

[HackerRank](E) Revising Aggregations - The Sum Function 본문

SQL/SQL 코딩 테스트-HackerRank

[HackerRank](E) Revising Aggregations - The Sum Function

밀뿌 2022. 3. 25. 15:57

https://www.hackerrank.com/challenges/revising-aggregations-sum/problem?isFullScreen=true 

 

Revising 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: 

 

 

[답]

- mysql

select sum(population) from city
where district = 'California'

'SQL > SQL 코딩 테스트-HackerRank' 카테고리의 다른 글

[HackerRank](E) Average Population  (0) 2022.03.25
[HackerRank](E) Revising Aggregations - Averages  (0) 2022.03.25
[HackerRank](E) Revising Aggregations - The Count Function  (0) 2022.03.25
[HackerRank](M) Binary Tree Nodes  (0) 2022.03.18
[HackerRank](M) The PADS  (0) 2022.03.18
'SQL/SQL 코딩 테스트-HackerRank' Related Articles more
Comments