Prepare > SQL > Basic Select > Weather Observation Station 4
2023. 7. 8. 22:11ㆍHackerRank-My SQL
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.
코드
SELECT COUNT(CITY) - COUNT(DISTINCT(CITY)) FROM STATION;
'HackerRank-My SQL' 카테고리의 다른 글
| Prepare > SQL > Basic Select > Weather Observation Station 6 (0) | 2023.07.09 |
|---|---|
| Prepare > SQL > Basic Select > Weather Observation Station 5 (0) | 2023.07.08 |
| Prepare >SQL > Basic Select > Weather Observation Station 3 (0) | 2023.07.06 |
| Prepare > SQL > Basic Select > Weather Observation Station 1 (0) | 2023.07.06 |
| Prepare >SQL > Basic Select > Japanese Cities' Names (0) | 2023.07.06 |