[해커랭크] Revising Aggregations - The Sum Function

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

 

❓문제

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

Input Format

The CITY table is described as follows: 

 

🔉 문제 설명

지역구가 California인 CITY의 총 인구수를 쿼리

 

❗답

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

 

---

🤔풀이

 SUM : 총