Weather Observation Station 4
- URL : https://www.hackerrank.com/challenges/weather-observation-station-4/problem
- Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table.
- MySQL, Oracle Solution
1
2
select (count(city) - count(distinct city))
from station;