select distinct city from station where city regexp '^[aeiou].*[aeiou]$';

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%') AND (CITY LIKE '%a' OR CITY LIKE '%e' OR CITY LIKE '%i' OR CITY LIKE '%o' OR CITY LIKE '%u') ;

For Oracle If some one searching for this 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%') AND ( CITY LIKE '%a' OR CITY LIKE '%e' OR CITY LIKE '%i' OR CITY LIKE '%o' OR CITY LIKE '%u');

select distinct city from station where lower(substr(city,1,1))in ('a', 'e', 'i', 'o', 'u') and lower(substr(city,length(city),length(city))) in ('a', 'e', 'i', 'o', 'u')

For performance (no regex) mysql;

select city from station where (left(city, 1)) in ('a','e','i','o','u')
		intersect
select city from station where (right(city, 1)) in ('a','e','i','o','u')