MySQL solution

From my HackerRank solutions.

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

$ matches End of string
[...] matches any character listed between the square brackets

Useful Regular Expression Reference

Let me know if you have any questions.