Weather Observation Station 4

Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table.
The STATION table is described as follows:

where LAT_N is the northern latitude and LONG_W is the western longitude.

 

 

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

 

 

Weather Observation Station 4 | HackerRank

Weather Observation Station 4 | HackerRank