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
CODE:
SELECT DISTINCT CITY FROM STATION WHERE CITY
RLIKE '^[^AEIOUaeiou]|[^aeiouAEIOU]$' ;
0 Comments