Hackerrank - Weather Observation Station 8 solution

Problem link

Solution one:

SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '^[AEIOU].+[AEIOU]$';