Weather Observation Station 10

  • + 0 comments

    select distinct(city) from station where city not like '%a' and city not like '%e' and city not like '%i' and city not like '%o' and city not like '%u';

    and

    select distinct(city) from station where right(city, 1) not in ('a','e','i','o','u');