Weather Observation Station 3
- URL : https://www.hackerrank.com/challenges/weather-observation-station-3/problem
- 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.
- MySQL Solution
1
2
3
select distinct(city)
from station
where (id % 2) = 0;