Hackerrank - Weather Observation Station 7 solution

Problem link

Solution one:

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