[해커랭크 SQL] Basic Select - Weather Observation Station 9

❓ Question

https://www.hackerrank.com/challenges/weather-observation-station-9

Weather Observation Station 9 | HackerRank

❗ Answer

SELECT DISTINCT(city)
    FROM station
    WHERE LEFT(city,1) NOT IN ('a','e','i','o','u')

📌 Discussion

- WHERE NOT IN 으로 포함되지 않는 조건을 걸어줌