Data Analyst/SQL

[Hackerrank-SQL] Weather Observation Station 8

e_mily.dy 2021. 8. 2. 20:08
728x90

Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot contain duplicates.

이름 처음과 끝이 모음으로 끝나는 도시를 중복없이 추출해라.