HackerRank - Weather Observation Station 9

April - 25/2025

Problem:

Query the list of CITY names from STATION that do not start 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, 1) NOT IN ('a', 'e', 'i', 'o', 'u')
    ORDER BY CITY ASC;

# Solution_02

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

Post: