Weather Observation Station 3

Query a list of CITY names from STATION for cities that have an even ID number. Print the results in any order, but exclude duplicates from the answer.
The STATION table is described as follows:

where LAT_N is the northern latitude and LONG_W is the western longitude.

 

*조건 : 짝수의 아이디 숫자를 가지고있는 도시들의 이름을 나오게 해야함

짝수는 2로 나누었을때 나머지가 0이니까

 

 

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

 

 

 

 

Weather Observation Station 3 | HackerRank

Weather Observation Station 3 | HackerRank