HackerRank MySQL - Weather Observation Station 9



Query the list of CITY names from STATION that do not start with vowels. Your result cannot contain duplicates.



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

download android app