데이터 분석 기술 블로그

Weather Observation Station 4 _ Easy. HackerRank 본문

SQL/문제풀이

Weather Observation Station 4 _ Easy. HackerRank

데이터분석가 이채은 2024. 9. 19. 09:00

 

Solution

SELECT COUNT(CITY) - COUNT(DISTINCT(CITY))
FROM STATION
WHERE 
    LAT_N > 0
AND 
    LONG_W > 0;