HackerRank - Weather Observation Station 7

April - 11/2025

Problem:

Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.

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 CITY LIKE '%A' OR
          CITY LIKE '%E' OR
          CITY LIKE '%I' OR
          CITY LIKE '%O' OR
          CITY LIKE '%U'
    ORDER BY CITY ASC;

# Solution_01

            
    SELECT DISTINCT CITY
    FROM STATION
    WHERE SUBSTR(LOWER(CITY), LENGTH(CITY), 1) IN ('a', 'e', 'i', 'o', 'u')
    ORDER BY CITY ASC;

# Solution_02

            
    SELECT DISTINCT CITY
    FROM STATION
    WHERE SUBSTR(LOWER(CITY), -1, 1) IN ('a', 'e', 'i', 'o', 'u')
    ORDER BY CITY ASC;

# Solution_03

            
    SELECT DISTINCT CITY
    FROM STATION
    WHERE RIGHT(LOWER(CITY), 1) IN ('a', 'e', 'i', 'o', 'u')
    ORDER BY CITY ASC;

Post: