Hackerrank - Weather Observation Station 12 solution

Problem link

Solution one:

SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '^[^AEIOU].+[^AEIOU]$';