All efficient solutions to HackerRank problems

Weather Observation Station 10

Problem Statement: Weather Observation Station 10
Points: 10
Difficulty: Easy

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"
)
order by CITY

Explanation: Selecting unique city from station table where city name not ends with vowels ( a, e, i, o, u ) and order by city name