Weather Observation Station 8

Sort by

recency

|

4805 Discussions

|

  • + 0 comments

    Real answer: SELECT DISTINCT CITY FROM STATION WHERE RIGHT(CITY,1) IN ('a', 'e', 'i', 'o', 'u') AND LEFT(CITY, 1) IN ('A','E','I','O','U');

  • + 0 comments

    select DISTINCT CITY FROM STATION WHERE SUBSTR(CITY,1,1) IN ('A' , 'E' , 'I' , 'O' , 'U') and UPPER(RIGHT(CITY,1)) IN ('A' , 'E' , 'I' , 'O' , 'U');

  • + 0 comments

    select CITY from STATION where CITY REGEXP '^[AEIOU].*[AEIOU]$'

  • + 0 comments

    select CITY from STATION where CITY REGEXP '^[AEIOU].*[AEIOU]$'

  • + 0 comments

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