[SQL][HackerRank] Weather Observation Station 8

https://www.hackerrank.com/challenges/weather-observation-station-8/problem

Weather Observation Station 8 | HackerRank

 

SELECT DISTINCT(CITY)
FROM Station
WHERE LEFT(CITY,1) in ('a','e','i','o','u') AND
RIGHT(CITY,1) in ('a','e','i','o','u');