SESSION NAME: Advance Select - 1
QUESTION NAME: Weather Observation - Vowels No Start.
TABLE DESCRIPTION:
Query the list of CITY names from STATION that do not
start with vowels. Your result cannot contain duplicates.
CODE:
select DISTINCT CITY from STATION where CITY RLIKE '^[^aeiouAEIOU]';
CODE:
select DISTINCT CITY from STATION where CITY RLIKE '^[^aeiouAEIOU]';
0 Comments