[HackerRank] Revising Aggregations - The Sum Function

2021. 1. 25. 21:51데이터베이스/SQL

728x90
반응형

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

 

Input Format

The CITY table is described as follows: 


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