Weather Observation Station 4 | HackerRank
Find the number of duplicate CITY names in STATION.
www.hackerrank.com
문제 조건
전체 city 수와 고유한 city 수의 차이를 구하시오
문제 풀이
SELECT (COUNT(CITY) - COUNT(DISTINCT CITY))
FROM STATION'SQL > Hacker Rank' 카테고리의 다른 글
| [Medium] Weather Observation Station 20 (0) | 2022.10.24 |
|---|---|
| [Medium] Weather Observation Station 19 (0) | 2022.10.24 |
| [Easy] Weather Observation Station 3 (0) | 2022.10.24 |
| [EASY] Weather Observation Station 1 (0) | 2022.10.24 |
| [MEDIUM] Weather Observation Station 18 (0) | 2022.10.13 |