Hackerrank - Weather Observation Station 8

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

Solution
Joins conditions of Weather Observation Station 6 and Weather Observation Station 7

I created solution in:

All solutions are also available on my GitHub.

SQL

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

select distinct city

from station

where

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

AND

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

order by city;

Pavol Pidanič

I can count to 1023 with 10 fingers

Hackerrank – Weather Observation Station 8