[해커랭크/SQL] 11. Weather Observation Station 6

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

Weather Observation Station 6 | HackerRank

---

🤔 문제 분석

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

 

💡 풀이

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