[해커랭크] Weather Observation Station 11

문제링크 : https://www.hackerrank.com/challenges/weather-observation-station-11/problem?isFullScreen=true

 

❓문제

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.

(모음으로 시작도 끝도 하지않음. 중복 허용 X)

 

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 CITY REGEXP '^[^aeiou]' OR CITY REGEXP '[^aeiou]$'

 

---

🤔풀이

Weather Observation Station 10과 유사한 문제

^[^aeiou] : 모음으로 시작하지 않는 문자열 찾기

[^aeiou]$ : 모음올  끝나지 않는 문자열 찾기