Prepare > SQL > Aggregation > Revising Aggregations - The Sum Function

Revising Aggregations - The Sum Function | HackerRank

 

문제

---

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

 

 

 

 

코드

---

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

 

 

 

두 번째 시도

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

• 똑같음