Hackerrank - Weather Observation Station 9

Problem Statement
A description of the problem can be found on Hackerrank.

Solution
As Weather Observation Station 6, only the condition is opposite.

I created solution in:

All solutions are also available on my GitHub.

SQL

select distinct city
from station
where lower(substr(city, 1, 1)) not in ('a', 'e', 'i', 'o', 'u')
    order by city asc;

select distinct city

from station

where lower(substr(city, 1, 1)) not in ('a', 'e', 'i', 'o', 'u')

order by city asc;

Pavol Pidanič