Hackerrank - Weather Observation Station 6 solution

Problem link

Solution one:

SELECT DISTINCT CITY FROM STATION WHERE CITY LIKE "A%" OR CITY LIKE "E%" OR CITY LIKE "I%" OR CITY LIKE "O%" OR CITY LIKE "U%";

Solution two:

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