TECH

Weather Observation Station 9

AKA.DM 2022. 6. 10. 08:23
반응형

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

Input Format

The STATION table is described as follows:

select distinct city
From station
minus 
select distinct city 
from station 
where regexp_like(city, '^[aeiou]', 'i');

select 두개 구문 

전체중복 리스트에서 minus 연산자를 통해 aeiou로 시작하는 도시를 제외하여 결과값을 도출함 

반응형

'TECH' 카테고리의 다른 글

Weather Observation Station 11  (0) 2022.06.10
Weather Observation Station 10  (0) 2022.06.10
Weather Observation Station 8  (0) 2022.06.10
Weather Observation Station 5  (0) 2022.06.09
코로나19로 인한 국내 관광 행태 변화 분석  (0) 2022.06.09