[해커랭크 SQL] Basic Select - Weather Observation Station 7

❓ Question

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

Weather Observation Station 7 | HackerRank

❗ Answer

SELECT DISTINCT(city)
    FROM station
    WHERE RIGHT(city,1) IN ('a','e','i','o','u');

📌 Discussion

- RIGHT(column,n)은 column의 data에서 오른쪽 끝부터 n번째까지 추출하는 함수