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