Weather Observation Station 11

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

Input Format

The STATION table is described as follows:

where LAT_N is the northern latitude and LONG_W is the western longitude.

 

*조건 모음으로 시작하거나 끝나는 단어들 없애버리기

-- 모음으로 시작할때 문자형은 대문자로 끝날때는 소문자로 하기,,, 

당연한곤뎈ㅋㅋ 생각을 못해서

엉뚱하게 헤맸음 ㅜ

 

 

SELECT distinct CITY 
FROM STATION
WHERE REGEXP_LIKE(CITY,'^[^AEIOU]') or not regexp_like(city,'[aeiou]$') ; 

 

 

 

 

Weather Observation Station 11 | HackerRank

Weather Observation Station 11 | HackerRank