Query data either don't start or don't end with vowels

Write a SQL query to get all cities either don't start with vowels or don't end with vowels from the STATION table using LOWER(), LENGTH() and SUBSTRING() function NOT IN and OR operators. This is the solution of HackerRank's Weather Observation Station 11 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')
OR LOWER(SUBSTRING(CITY, 1, 1)) NOT IN ('a', 'e', 'i', 'o', 'u')