Weather Observation Station 3
HackerRank SQL Problem:
Query a list of CITY names from STATION with even ID numbers only. You may print the results in any order, but must exclude duplicates from your answer.
This is the “Easy” level. And we only have to be careful to use modulus for finding even numbers, and use “distinct” function.
select distinct city from station where (id % 2) = 0;