HackerRank - Weather Observation Station 3

April - 25/2025

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.

The STATION table is described as follows:

Field Type
ID NUMBER
CITY VARCHAR2(21)
STATE VARCHAR2(2)
LAT_N NUMBER
LAT_W NUMBER

where LAT_N is the northern latitude and LONG_W is the western longitude.

# Solution

            
    SELECT DISTINCT CITY
    FROM STATION
    WHERE MOD(ID, 2) = 0;

# Solution_01

            
    SELECT DISTINCT CITY
    FROM STATION
    WHERE ID % 2 = 0;

Post: