Hackerrank - Weather Observation Station 4 solution

Problem link

Solution one:

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