HackerRank MySQL - Weather Observation Station 12
Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates.
- SELECT DISTINCT(CITY)
- FROM STATION
- WHERE REGEXP_LIKE(CITY, '^[^AEIOU].*[^AEIOU]$', 'i');