Query data that don't start with vowels using SQL LOWER() and SUBSTRING() functions and NOT IN Operator

Author: Al-mamun Sarkar Date: 2020-03-28 09:38:06

Write a SQL query to get all cities that don't start with vowels from the STATION table using LOWER() and SUBSTRING() functions and NOT IN Operator. This is the solution of HackerRank's Weather Observation Station 9 SQL problem.

Table name: STATION

Table Structure:

Fileds Type
ID NUMBER
CITY VARCHAR
STATE VARCHAR
LAT_N NUMBER
LONG_W NUMBER

 

SQL Query:

SELECT DISTINCT CITY
FROM STATION
WHERE LOWER(SUBSTRING(CITY, 1, 1)) NOT IN ('a', 'e', 'i', 'o', 'u')