Files
HackerRank-Solutions/SQL/Basic Select/Weather Observation Station 4.sql

9 lines
178 B
SQL

-- Author: Rodney Shaghoulian
-- Github: github.com/RodneyShag
-- HackerRank: hackerrank.com/RodneyShag
SELECT
COUNT(CITY) - COUNT(DISTINCT CITY)
FROM
STATION;