[HackerRank] Revising Aggregations - The Sum Function 오라클(Oracle)

@notepad_jj2

츄르사려고 코딩하는집사입니다.

---

1. [HackerRank] Revising Aggregations - The Sum Function 오라클(Oracle)

 

2. 문제 출처

https://www.hackerrank.com/challenges/revising-aggregations-sum/problem

Revising Aggregations - The Sum Function | HackerRank

 

3. 문제

Query the total population of all cities in CITY where District is California.

Input Format

The CITY table is described as follows: 

4. 풀이

- CITY 테이블에서 DISTRICT가 California인 인구(POPULATION)의 합을 출력하라.

 

5. 소스 코드

 

SELECT SUM(POPULATION)
FROM CITY
WHERE DISTRICT = 'California';

---