Weather Observation Station 7

Weather Observation Station 7 | HackerRank

Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION.

https://www.hackerrank.com/challenges/weather-observation-station-7/problem?h_r=internal-search

SELECT DISTINCT(CITY)
FROM STATION
WHERE CITY REGEXP '.*[aeiou]$'
Python
복사