CODE EXAMPLE FOR SQL

sql name ends with vowels

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