All efficient solutions to HackerRank problems

Weather Observation Station 12

Problem Statement: Weather Observation Station 12
Points: 15
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"
  )
  and 
  (
    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 starts and ends with vowels ( a, e, i, o, u ) and order by city name