[HackerRank][SQL] Weather Observation Station 12 - 컴도리돌이

Weather Observation Station 12 | HackerRank

---

 

Problem

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

-> 도시 이름의 시작과 끝이 모음이 포함하지 않는 도시의 이름을 중복 없이 출력하시오.

---

Answer

select distinct(city) 
from station 
where city regexp "[^aeiou]$" and city regexp "^[^aeiou]"