Weather Observation Station 11

Sort by

recency

|

4091 Discussions

|

  • + 0 comments

    select distinct city from station where city not like '[AEIOU]%[aeiou]';

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

    OR CITY NOT LIKE '%a' AND CITY NOT LIKE '%e' AND CITY NOT LIKE '%i' AND CITY NOT LIKE '%o' AND CITY NOT LIKE '%u';

  • + 0 comments

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

  • + 0 comments

    SELECT CITY FROM STATION WHERE LEFT(UPPER(CITY),1) NOT IN ('A','E','I','O','U') AND RIGHT(LOWER(CITY),1) NOT IN ('a','e','i','o','u');

  • + 0 comments

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