SELECT DISTINCT CITY
FROM STATION
WHERE LEFT(CITY, 1) NOT IN ('a', 'e', 'i', 'o', 'u','A','E','I','O','U');

Simpler answer just add 'NOT' in front of the 'IN' for simpler logic