A description of the problem can be found on Hackerrank.
As Weather Observation Station 6, only the condition is opposite.
I created solution in:
All solutions are also available on my GitHub.
select distinct city
where lower(substr(city, 1, 1)) not in ('a', 'e', 'i', 'o', 'u')
order by city asc;