[Hacker Rank/mysql] Weather Observation Station 10

Problem

Station 테이블에서 중복제거 한다음 마지막 글자가 AEIO가 아닌 값들을 출력

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-10