Hackerrank - Weather Observation Station 7

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

Solution
Almost the same principle as Weather Observation Station 6, only substring is different.

I created solution in:

All solutions are also available on my GitHub.

SQL

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

select distinct city

from station

where

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

order by city;

Pavol Pidanič