We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Weather Observation Station 8
Weather Observation Station 8
Sort by
recency
|
4805 Discussions
|
Please Login in order to post a comment
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');
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');
select CITY from STATION where CITY REGEXP '^[AEIOU].*[AEIOU]$'
select CITY from STATION where CITY REGEXP '^[AEIOU].*[AEIOU]$'
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');