[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';
'데이터베이스 > SQL' 카테고리의 다른 글
[HackerRank] Weather Observation Station 13 (0) | 2021.02.08 |
---|---|
[HackerRank] Weather Observation Station 2 (0) | 2021.02.08 |
[HackerRank] Revising Aggregations - The Count Function (0) | 2021.01.25 |
[HackerRank] Employee Salaries (0) | 2021.01.25 |
[HackerRank] Higher Than 75 Marks (0) | 2021.01.24 |