Weather Observation Station 11 _ Easy. HackerRank

 

Solution1

SELECT DISTINCT(CITY)
FROM STATION
WHERE CITY REGEXP '^[^aeiouAEIOU]'
    OR CITY REGEXP '[^aeiouAEIOU]$';

 

Solution 2

SELECT DISTINCT(CITY)
FROM STATION
WHERE CITY NOT REGEXP '^[aeiouAEIOU]'
    OR CITY NOT REGEXP '[aeiouAEIOU]$';