https://www.hackerrank.com/challenges/weather-observation-station-4/problem
Weather Observation Station 4 | HackerRank
Find the number of duplicate CITY names in STATION.
www.hackerrank.com
Find the difference between the total number of CITY entries in the table and the number of distinct CITY entries in the table. The STATION table is described as follows:
전체 CITY 수와 겹치지 않는 CITY 수를 빼는 문제
반응형
'지식저장소 > SQL' 카테고리의 다른 글
| [SQL/MYSQL] HackerRank - Weather Observation Station 9 (0) | 2022.06.10 |
|---|---|
| [SQL/MYSQL] HackerRank - Weather Observation Station 8 (0) | 2022.06.10 |
| [SQL/MYSQL] HackerRank - Weather Observation Station 7 (0) | 2022.06.10 |
| [SQL/MYSQL] HackerRank - Weather Observation Station 6 (0) | 2022.06.10 |
| [SQL/MYSQL] HackerRank - Weather Observation Station 5 (0) | 2022.06.10 |