-
[HackerRank/Basic Select] Weather Observation Station 4공부/PS ( SQL) 2022. 5. 15. 22:48
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
문제
풀이
SELECT COUNT(CITY) - COUNT(DISTINCT(CITY)) FROM STATION
'공부 > PS ( SQL)' 카테고리의 다른 글
[HackerRank/Basic Select] Weather Observation Station 6 (0) 2022.05.15 [HackerRank/Basic Select] Weather Observation Station 5 (0) 2022.05.15 w3schools - sql exercise (1) (0) 2021.11.30 [HackerRank/Basic Select] Weather Observation Station 3 (0) 2021.09.24 [HackerRank/Basic Select] Weather Observation Station 1 (0) 2021.09.24