SQL(HackerRank_Weather Observation Station 3)

 

Problem Link

https://www.hackerrank.com/challenges/weather-observation-station-3/problem?isFullScreen=true

 

출처 - HackerRank

Solution

SELECT DISTINCT CITY FROM STATION
WHERE MOD(ID,2) = 0

 

Using MOD function

* MOD(A,B) : A를 B로 나눈 나머지

 

Reference : https://blog.naver.com/regenesis90/222180828623