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 7
Weather Observation Station 7
Sort by
recency
|
3224 Discussions
|
Please Login in order to post a comment
SELECT DISTINCT CITY FROM STATION WHERE RIGHT(CITY, 1) IN ('A', 'E', 'I', 'O', 'U');
SELECT DISTINCT CITY FROM STATION WHERE CITY LIKE '%a' OR CITY LIKE '%e' OR CITY LIKE '%i' OR CITY LIKE '%o' OR CITY LIKE '%u';
SELECT DISTINCT CITY FROM STATION WHERE RIGHT(CITY,1) IN ("A","E","I","O","U") ;
select distinct city from station where city regexp '[aeiou]$';
SELECT DISTINCT CITY FROM STATION WHERE RIGHT(CITY, 1) IN ('A', 'E', 'I', 'O', 'U');