Weather Observation Station 9

Question Link

Query the list of CITY names from STATION that do not start with vowels. Your result cannot contain duplicates.

where LAT_N is the northern latitude and LONG_W is the western longitude.

SELECT DISTINCT city
FROM Station
WHERE NOT (city LIKE 'A%' 
    OR city LIKE 'E%' 
    OR city LIKE 'I%' 
    OR city LIKE 'O%' 
    OR city LIKE 'U%');

Last updated