[HackerRank] Weather Observation Station 3

mzzzi·2022년 4월 18일
0

HackerRank SQL

목록 보기
8/52
post-thumbnail

MySQL > 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.


My Answer


SELECT DISTINCT CITY
FROM STATION
WHERE MOD(ID,2) = 0
profile
무럭무럭 성장하라🌳

0개의 댓글