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

1. 문제

Query a count of the number of cities in CITY having a Population larger than 100,000.

(larger than=초과)

 

 

 

2. 내풀이

SELECT COUNT(ID)
FROM CITY
WHERE POPULATION > 100000

 

 

 

3. 결과