본문 바로가기

Language/SQL

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

728x90
 

Weather Observation Station 9 | HackerRank

Query an alphabetically ordered list of CITY names not starting with vowels.

www.hackerrank.com


Problem

 

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

-> 모음으로 시작하지 않는 도시 이름을 중복 없이 출력하시오.


Answer

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