공부/PS ( SQL)
[HackerRank/Basic Select] Weather Observation Station 7
happyst
2022. 5. 15. 23:21
https://www.hackerrank.com/challenges/weather-observation-station-7/problem
Weather Observation Station 7 | HackerRank
Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION.
www.hackerrank.com
문제
풀이
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'