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으로 조건문에 포함되지 않는 레코드 추출