Hackerrank - Weather Observation Station 11

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

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

I created solution in:

All solutions are also available on my GitHub.

SQL

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

select distinct city

from station

where

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;

Pavol Pidanič

I can count to 1023 with 10 fingers

Hackerrank – Weather Observation Station 11