[해커랭크/SQL] 8. Weather Observation Station 3

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

Weather Observation Station 3 | HackerRank

 

---

🤔 문제 분석

1) Query a list of CITY names from STATION for cities that have an even ID number.

2) Print the results in any order, but exclude duplicates from the answer.

 

💡 풀이

SELECT DISTINCT CITY
FROM STATION
WHERE ID % 2 = 0