SQL 문제풀이

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

냄비짱 2023. 8. 18. 21:57
728x90

❓ Question

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

 

Weather Observation Station 10 | HackerRank

Query a list of CITY names not ending in vowels.

www.hackerrank.com

❗ Answer

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

📌 Discussion

- WHERE NOT IN으로 조건문에 포함되지 않는 레코드 추출