SESSION NAME: Advance Select - 2.
QUESTION NAME: Weather Observation Station 12. TABLE DESCRIPTION: Query the list of CITY names from STATION that do not startwith vowels and do not end with vowels.
Your result cannot contain duplicates.
CODE:
select distinct CITY from STATION
where CITY RLIKE '^[^AEIOUaeiou].+[^AEIOUaeiou]$';
0 Comments