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:
where LAT_N is the northern latitude and LONG_W is the western longitude.
SELECT COUNT(CITY) - COUNT(DISTINCT CITY)
FROM STATION ;
Weather Observation Station 4 | HackerRank
Weather Observation Station 4 | HackerRank
Find the number of duplicate CITY names in STATION.
www.hackerrank.com
'문제풀이 > HackerRank' 카테고리의 다른 글
| weather observation station 6 (0) | 2022.11.02 |
|---|---|
| Weather Observation Station 5 (0) | 2022.11.02 |
| Weather Observation Station 3 (0) | 2022.11.02 |
| Weather Observation Station 1 (0) | 2022.11.02 |
| Japanese Cities' Names (0) | 2022.11.02 |
