[Hacker Rank/mysql] Weather Observation Station 9

Problem

Station 테이블에서 첫글자가 AEIOU가 아닌 결과 조회

MYSQL정규식

SELECT DISTINCT CITY 
FROM STATION
WHERE CITY NOT REGEXP '^[AEIOU]'

SQL Server like

SELECT DISTINCT CITY 
FROM STATION
WHERE CITY NOT LIKE '[AEIOU]%'

문제 링크

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