31 January 2018

Weather Observation Station 11

My solution:
SELECT DISTINCT CITY 
FROM   STATION 
WHERE  CITY REGEXP "^.*[^aeiou]$" 
        OR CITY REGEXP "^[^AEIOU].*$";