[해커랭크/SQL] 12. Weather Observation Station 7

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

Weather Observation Station 7 | HackerRank

 

---

🤔 문제 분석

1) Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.

 

💡 풀이

SELECT DISTINCT CITY
FROM STATION
WHERE CITY LIKE "%a"
OR CITY LIKE "%e"
OR CITY LIKE "%i"
OR CITY LIKE "%o"
OR CITY LIKE "%u"