Weather Observation Station 12(hackerrank).sql

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