[Hackerrank] Weather Observation Station 4

PROBLEM

문제점

개수 세는 함수가 뭐더라?

SELECT NUM(CITY)- (SELECT DISTINCT NUM(CITY)) 
FROM STATION

정답풀이

COUNT 함수였군

SELECT COUNT(CITY) - COUNT(DISTINCT(CITY))
FROM STATION