HackerRank MySQL - Weather Observation Station 7



Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.



  1. SELECT DISTINCT CITY
  2. FROM STATION
  3. WHERE UPPER(SUBSTR(CITY, -1)) IN ('A','E','I','O','U');

download android app