HackerRank_18. Weather Observation Station 12

문제 : Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates.

 

SELECT distinct CITY
FROM STATION
WHERE SUBSTR(CITY, 1, 1) NOT IN ('a', 'e', 'i', 'o', 'u')
AND SUBSTR(CITY, -1, 1) NOT IN ('a', 'e', 'i', 'o', 'u');

Baker Baldwin Bass Harbor Beaufort Beaver Island Benedict Bennington Berryton Beverly Bison Blue River Bowdon Bowdon Junction Bridgeport Bridgton Brighton Brilliant Bristol Brownstown Buffalo Creek {-truncated-}