SQL

starts and end with vowel sql

SELECT DISTINCT CITY 
FROM STATION  
WHERE CITY LIKE '[AEIOU]%' and CITY LIKE '%[aeiou]';

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;

starts and end with vowel sql

SELECT DISTINCT CITY 
FROM STATION  
WHERE CITY regexp '^[AEIOU]%' and CITY regexp '[aeiou]$';