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.



  1. SELECT DISTINCT(CITY)
  2. FROM STATION
  3. WHERE REGEXP_LIKE(CITY, '^[^AEIOU].*[^AEIOU]$', 'i');

download android app