A description of the problem can be found on Hackerrank.
Joins conditions of Weather Observation Station 6 and Weather Observation Station 7
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;