Weather Observation Station 11

Sort by

recency

|

4076 Discussions

|

  • + 0 comments

    SELECT DISTINCT city FROM station WHERE city NOT REGEXP '^[aeiou].*[aeiou]$'

  • + 0 comments

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

  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE CITY NOT REGEXP '^(A|E|I|O|U).*(a|e|i|o|u)$'

  • + 0 comments
    SELECT DISTINCT CITY FROM STATION 
    WHERE CITY NOT REGEXP  '^[aeiou].*[aeiou]$'
    
  • + 0 comments

    select distinct city from station where (city like '[^aeiou]%' or city like '%[^aeiou]' )