A description of the problem can be found on Hackerrank.
I created solution in:
All solutions are also available on my GitHub.
select distinct city
substr(lower(city), 1, 1) in ('a', 'e', 'i', 'o', 'u')
substr(lower(city), length(city), 1) in ('a', 'e', 'i', 'o', 'u')
order by city;