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 6
Weather Observation Station 6
Sort by
recency
|
4739 Discussions
|
Please Login in order to post a comment
SELECT DISTINCT city FROM station WHERE LOWER(SUBSTRING(city, 1, 1)) IN ('a', 'e', 'i', 'o', 'u');
SELECT DISTINCT city
FROM station
WHERE LEFT(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 ( 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 ( CITY LIKE 'A%' OR CITY LIKE 'E%' OR CITY LIKE 'I%' OR CITY LIKE 'O%' OR CITY LIKE 'U%' );