[Hacker Rank/mysql] Weather Observation Station 7

Problem

where LAT_N is the northern latitude and LONG_W is the western longitude.

SQL SERVER

Station Table에서 중복 제외 AEIOU로 끝나는 값들을 조회

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

Mysql

SELECT DISTINCT CITY
FROM STATION
WHERE CITY REGEXP '[AEIOU]$'

REGEXP '[AEIOU]$': 정규식에서 끝 글글자가 AEIOU라는 값 출력

문제링크

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