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

Write a SQL query to get all cities that don't end 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 10 SQL problem.

Table name: STATION

Table Structure:

SQL Query:

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