👉https://www.hackerrank.com/challenges/weather-observation-station-4/problem?isFullScreen=true
Weather Observation Station 4 | HackerRank
Find the number of duplicate CITY names in STATION.
www.hackerrank.com
🤔 문제 분석
1) Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table.
💡 풀이
SELECT COUNT(CITY) - COUNT(DISTINCT CITY)
FROM STATION'코딩테스트 > 해커랭크 SQL' 카테고리의 다른 글
| [해커랭크/SQL] 11. Weather Observation Station 6 (0) | 2023.02.15 |
|---|---|
| [해커랭크/SQL] 10. Weather Observation Station 5 (0) | 2023.02.15 |
| [해커랭크/SQL] 8. Weather Observation Station 3 (0) | 2023.02.15 |
| [해커랭크/SQL] 7. Japanese Cities' Attributes (0) | 2023.02.15 |
| [해커랭크/SQL] 6. Weather Observation Station 1 (0) | 2022.12.11 |
댓글