Weather Observation Station 10

Sort by

recency

|

2207 Discussions

|

  • + 0 comments

    select distinct city from station where city regexp '[^a,e,i,o,u]$';

  • + 0 comments

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

  • + 0 comments

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

  • + 0 comments

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

  • + 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' ;