HackerRank - Weather Observation Station 10

April - 25/2025

Problem:

Query the list of CITY names from STATION that do not end with vowels. 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 NOT LIKE '%A' AND
          CITY NOT LIKE '%E' AND
          CITY NOT LIKE '%I' AND
          CITY NOT LIKE '%O' AND
          CITY NOT LIKE '%U';

# Solution_01

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

# Solution_02

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

Post: