A description of the problem can be found on Hackerrank.
Almost the same principle as Weather Observation Station 6, only substring is different.
I created solution in:
All solutions are also available on my GitHub.
select distinct city
substr(lower(city), length(city), 1) in ('a', 'e', 'i', 'o', 'u')
order by city;