SQL

Substring - 1 = index and another 1 is just one character

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

AEIOU NOT IN START OR END

SELECT DISTINCT CITY FROM STATION WHERE LOWER(SUBSTR(CITY,1,1)) NOT IN ('a','e','i','o','u') OR LOWER(SUBSTR(CITY, LENGTH(CITY),1)) NOT IN ('a','e','i','o','u');