Hackerrank - Weather Observation Station 4 solution

Solution one:

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