Talk is cheap. Show me the code.
Problem : https://www.hackerrank.com/challenges/weather-observation-station-3/problem
Solution :
/*
Enter your query here.
*/
SELECT DISTINCT(CITY) FROM STATION WHERE ID%2=0;