Make sure the vowels are written in lowercase for the query to work if you have solved the previous problem it wasnt working without the vowels being written in uppercase here it wont work unless it is lowercase SQL being case sensitive this shouldnt happen

select distinct city from station where right(city,1) in ('A','a','E','e','I','i','O','o','U','u') group by city;

MS SQL Server:

select distinct city 
from station 
where right(city,1) in ('A','a','E','e','I','i','O','o','U','u') 
group by city;

select distinct city from Station where Right(city,1) IN ('a' ,'e','i','o', 'u')

select distinct city from station where city like '%a' or city like '%e' or city like '%i' or city like '%o' or city like '%u'; ** .......OR........ **select distinct city from station where substr(city,-1,1) in ('a','o','i','e','u');