Weather Observation Station 11

Sort by

recency

|

4097 Discussions

|

  • + 0 comments

    SELECT DISTINCT city FROM station WHERE CITY NOT REGEXP '^[AEIOU].*[AEIOU]$';

  • + 0 comments

    SELECT DISTINCT city FROM station WHERE CITY NOT REGEXP '^[AEIOUaeiou]' OR CITY NOT REGEXP '[AEIOUaeiou]$'

  • + 0 comments

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

  • + 2 comments

    select distinct city from station where not upper(left(city,1)) in ('A','I','E','O','U') AND not upper(right(city,1)) in ('A','I','E','O','U');

    why it shows error

  • + 0 comments

    Select distinct city from station where left(City,1) Not in ("a", "e", "i", "o", "u") or right(City,1) Not in ("a", "e", "i", "o", "u")