Weather Observation Station 8

[ji-0630]

문제 설명

[ji-0630]

나의 풀이

select distinct city
from station
where substr(city, 1, 1) in ('a', 'e', 'i', 'o', 'u')
and substr(city, -1, 1) in ('a', 'e', 'i', 'o', 'u')

[ji-0630]

다시 풀기

select distinct CITY
from STATION
where CITY regexp "^[aeiou]"
and CITY regexp "[aeiou]$"