728x90
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]"
728x90
728x90
'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 |