Weather Observation Station 12

Sort by

recency

|

2444 Discussions

|

  • + 0 comments

    select distinct city from station where city not regexp '^[aiueo]' and city not regexp '[aiueo]$'

  • + 0 comments

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

  • + 0 comments

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

  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '^[^AEIOU].*[^AEIOU]$'

  • + 0 comments

    Any of the query can be used

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

    select distinct city from station where city regexp '^[^aeiou]' and city regexp '[^aeiou]$';