All efficient solutions to HackerRank problems

Weather Observation Station 11

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