[해커랭크/SQL] 15. Weather Observation Station 10 (REGEXP)

👉 https://www.hackerrank.com/challenges/weather-observation-station-10/problem?isFullScreen=true

Weather Observation Station 10 | HackerRank

---

 

🤔 문제 분석

1) Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates.

 

💡 풀이

SELECT DISTINCT CITY
FROM STATION
WHERE CITY REGEXP "[^a|e|i|o|u]$"