Weather Observation Station 8

  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE UPPER(SUBSTR(CITY,1,1)) IN ('A','E','I','O','U') AND UPPER(SUBSTR(CITY,LENGTH(CITY),1)) IN ('A','E','I','O','U');