select distinct city from station where lower(right(city,1)) in ('a','e','i','o','u');

cara 1: SELECT DISTINCT city FROM station WHERE RIGHT (city, 1) IN ('A', 'E', 'I', 'O', 'U');

cara 2: SELECT DISTINCT city FROM station WHERE city REGEXP '[aeiou]$';

oracle sql, used group by city insted of distinct city, I don't know reason but I looked funny so I added it.

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

For MYSQL

select distinct city from station
where right(city, 1) in ("a", "e", "i", "o", "u")
and lat_n = 0 < lat_n < 90
and long_w = 180 < long_w < 180

select distinct city from station where lower(right(city,1)) in ("a","e","i","o","u")