[HackerRank] Revising Aggregations - The Count Function

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

SELECT COUNT(DISTINCT NAME) AS Output
FROM CITY
WHERE POPULATION > 100000