Hackerrank - Weather Observation Station 9 solution

Problem link

Solution one:

SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP "^[^AEIOU]"