Weather Observation Station 12(HackerRank)

https://www.hackerrank.com/challenges/weather-observation-station-12/problem?isFullScreen=true 

Weather Observation Station 12 | HackerRank

 

 

문제

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 CITY NOT LIKE 'a%' 
AND CITY NOT LIKE 'i%' 
AND CITY NOT LIKE 'e%' 
AND CITY NOT LIKE 'o%' 
AND CITY NOT LIKE 'u%' 
AND CITY NOT LIKE '%a' 
AND CITY NOT LIKE '%i' 
AND CITY NOT LIKE '%e' 
AND CITY NOT LIKE '%o' 
AND CITY NOT LIKE '%u'

해설

NOT LIKE를 사용하고 AND로 묶어주면서 모음으로 시작하지 않고 모음으로 끝나지 않는 결과값들을 필터링한다.