[HackerRank/Basic Select] Weather Observation Station 8

https://www.hackerrank.com/challenges/weather-observation-station-8/problem 

Weather Observation Station 8 | HackerRank

 

문제

풀이

SELECT DISTINCT CITY FROM STATION
WHERE CITY REGEXP "^[aeiou]" AND CITY REGEXP "[aeiou]$"

 

 

• 정규표현식 사용
• 컬럼명 REGEXP "^[시작할 문자열]" AND 컬럼명 REGEXP "[끝나는 문자열]$"