Weather Observation Station 4 | HackerRank
Find the number of duplicate CITY names in STATION.
www.hackerrank.com
select count(*) - count(DISTINCT CITY)
from STATION;
'Algorithm > SQL' 카테고리의 다른 글
| [SQL][HackerRank] Weather Observation Station 6 (0) | 2020.06.08 |
|---|---|
| [SQL][HackerRank] Weather Observation Station 5 (0) | 2020.06.08 |
| [SQL][HackerRank] Weather Observation Station 3 (0) | 2020.06.08 |
| [SQL][HackerRank] Weather Observation Station 1 (0) | 2020.06.08 |
| [SQL][HackerRank] Japanese Cities' Names (0) | 2020.06.08 |
