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

FOR ORACLE:

select distinct city from station where (((city not like 'A%') and (city not like 'E%') and (city not like 'I%') and (city not like 'O%') and(city not like 'U%')) or ((city not like '%a') and(city not like '%e') and (city not like '%i') and (city not like '%o') and (city not like '%u')));

SELECT DISTINCT city FROM station WHERE left(city, 1) NOT IN ('A', 'E', 'I', 'O', 'U') OR right(city, 1) NOT IN ('a', 'e', 'i', 'o', 'u');

THIS ONE IS CORRECT

MS SQL SERVER

11TH ANSWER select distinct(city) from station where city not like '[aeiou]%' or city not like '%[aeiou]'

SQL SERVER

SELECT DISTINCT City FROM Station WHERE LEFT(City,1) NOT LIKE '%[aeiou]' OR RIGHT(City,1) NOT LIKE '%[aeiou]'