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

해커랭크 Weather Observation Station SQL

+ Recent posts