Weather Observation Station 4 | Basic Select | SQL | Easy | HackerRank | Solution

 

Problem : https://www.hackerrank.com/challenges/weather-observation-station-4/problem

Solution : 

/*

Enter your query here.

*/

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