Weather Observation Station 8

SELECT DISTINCT(CITY)
FROM STATION
WHERE CITY REGEXP '^[aeiou]' AND CITY REGEXP '[aeiou]$'
Python
복사

SELECT DISTINCT(CITY)
FROM STATION
WHERE CITY REGEXP '^[aeiou].*[aeiou]$'
Python
복사