[SQL] 해커랭크 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.

 

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

Weather Observation Station 11 | HackerRank

문제 풀이

SELECT DISTINCT city
FROM station
WHERE city NOT REGEXP '^[aeiou].*' 
    OR city NOT REGEXP '.*[aeiou]$'

SELECT DISTINCT city
FROM station
WHERE (city NOT LIKE 'a%' 
    AND city NOT LIKE 'e%' 
    AND city NOT LIKE 'i%' 
    AND city NOT LIKE 'o%' 
    AND city NOT LIKE 'u%') 
    OR (city NOT LIKE '%a' 
    AND city NOT LIKE '%e' 
    AND city NOT LIKE '%i' 
    AND city NOT LIKE '%o' 
    AND city NOT LIKE '%u')

---

SQL을 독학하시는 분들에게 도움이 되길 바라며,

혹 더 좋은 방법이 있거나 오류가 있다면 편하게 말씀 부탁드립니다.