SELECT (SELECT COUNT(CITY) FROM STATION) - (SELECT COUNT(DISTINCT(CITY)) FROM STATION) AS COUNT
FROM DUAL해커랭크 Weather Observation Station SQL
'SQL > 해커랭크' 카테고리의 다른 글
| [SQL] 해커랭크 Weather Observation Station 9 (0) | 2022.09.01 |
|---|---|
| [SQL] 해커랭크 Weather Observation Station 8 (0) | 2022.08.31 |
| [SQL] 해커랭크 Weather Observation Station 6~7 (0) | 2022.08.31 |
| [SQL] 해커랭크 Weather Observation Station 5 (0) | 2022.08.31 |
| [SQL] 해커랭크 Weather Observation Station 3 (0) | 2022.08.31 |