Hackerrank – Weather Observation Station 3

Problem Statement
A description of the problem can be found on Hackerrank.

Solution
Select cities then filter if ID modulo 2 equals to 0 and order alphabetically ascending.

I created solution in:

All solutions are also available on my GitHub.

SQL

select distinct city 
  from station 
where 
  MOD(id, 2) = 0
order by city asc;

select distinct city

from station

where

MOD(id, 2) = 0

order by city asc;