Snoopy [해커랭크/SQL] 23. Revising Aggregations - The Sum Function
코딩테스트/해커랭크 SQL

[해커랭크/SQL] 23. Revising Aggregations - The Sum Function

Sooyoon Jeong 2023. 3. 6.
 

 

🤔 문제 분석

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

 

💡 풀이

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

 

댓글