Weather Observation Station 7

  • + 7 comments

    I made it a bit more simple:

    SELECT DISTINCT CITY FROM STATION WHERE RIGHT(CITY,1) IN ('a','e','i','o','u');