[MySQL] 해커랭크 집계함수 연습 (Revising Aggregations - The Sum Function)

1. 문제

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

 

 

 

2. 내풀이

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

 

 

 

3. 결과