Files
HackerRank-Solutions/SQL/Basic Select/Weather Observation Station 8.sql

7 lines
187 B
SQL

-- Author: Rodney Shaghoulian
-- Github: github.com/RodneyShag
-- HackerRank: hackerrank.com/RodneyShag
SELECT DISTINCT CITY FROM STATION
WHERE CITY REGEXP '^[aeiou].*[aeiou]$';