카테고리 없음
HackerRank_18. Weather Observation Station 12
_S0_H2_
2020. 6. 12. 01:12
728x90
반응형
문제 : 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-}
728x90
반응형