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
|
4705 Discussions
|
Please Login in order to post a comment
-- query the list of city names from station which have vowels a,i,o, and u as both first and last
SELECT DISTINCT(CITY)
FROM STATION
SELECT DISTINCT CITY FROM STATION WHERE LOWER(LEFT (CITY,1))IN ('a','e','i','o','u') and lower(right(city,1))IN('a','e','i','o','u');
select distinct city from station where left(city,1) IN ('a','e','i','o','u')AND right(city,1)IN ('a','e','i','o','u') ;
SELECT DISTINCT CITY FROM STATION WHERE LOWER(LEFT(CITY,1)) IN ('a','e','i','o','u') AND LOWER(RIGHT(CITY,1)) IN ('a','e','i','o','u');
This worked for me , first i kept getting it wrong and added lower.
select distinct city from station where city regexp '^[aeiouAEIOU].*[aeiouAEIOU]$';