SESSION NAME: Advance Select - 1

QUESTION NAME: Weather Observation Station 11


TABLE DESCRIPTION:
Query the list of CITY names from STATION that either do not start with vowels or do not end with vowels. Your result cannot contain duplicates.

CODE:
SELECT DISTINCT CITY FROM STATION WHERE CITY 
RLIKE '^[^AEIOUaeiou]|[^aeiouAEIOU]$' ;