[SQL] 해커랭크 Weather Observation Station 9

문제

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:

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

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

Weather Observation Station 9 | HackerRank

문제 풀이

SELECT DISTINCT city
FROM station
WHERE 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%'

---

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

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