xxxxxxxxxx
select distinct city
from station
where substring(city,len(city),1) in ('a','e','u','o','i')
order by city;
xxxxxxxxxx
SELECT DISTINCT CITY
FROM STATION
WHERE CITY LIKE '[AEIOU]%' and CITY LIKE '%[aeiou]';
xxxxxxxxxx
SELECT DISTINCT CITY
FROM STATION
WHERE CITY regexp '^[AEIOU]%' and CITY regexp '[aeiou]$';
xxxxxxxxxx
select city from station where city regexp '^[aeiouAEIOU]'
AND
SUBSTR(CITY,LENGTH(CITY),1) IN ('a','e','i','o','u')