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

7 lines
189 B
SQL

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