Weather Observation Station 11 (HackerRank)

Weather Observation Station 11 | HackerRank

Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.

풀이

제출한 답

select distinct city
from station
where city not regexp '^[aeiou].*[aeiou]$'

-> .은 어떤 문자든 일치, *은 문자를 여러 번 반복

2022.11.06