Hackerrank - Weather Observation Station 12

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

Solution
Only difference between Weather Observation Station 11 is 'AND'.

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')
     and
  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')

and

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 12