728x90
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]"
'Language > SQL' 카테고리의 다른 글
[HackerRank][SQL] Weather Observation Station 12 - 컴도리돌이 (0) | 2022.05.19 |
---|---|
[HackerRank][SQL] Weather Observation Station 10 - 컴도리돌이 (0) | 2022.05.18 |
[HackerRank][SQL] Weather Observation Station 8 - 컴도리돌이 (0) | 2022.05.18 |
[HackerRank][SQL] Weather Observation Station 7 - 컴도리돌이 (0) | 2022.05.18 |
[HackerRank][SQL] Weather Observation Station 6 - 컴도리돌이 (0) | 2022.05.18 |