We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
select distinct city from station
where
NOT (REGEXP_LIKE(SUBSTR(CITY, 1, 1), '^[AEIOUaeiou]')
AND REGEXP_LIKE(SUBSTR(CITY, -1, 1), '[AEIOUaeiou]$'))
order by city;
The solution pass the test but
In my solutions i have several problems :
Weather Observation Station 11
You are viewing a single comment's thread. Return to all comments →
-- ORACLE SQL
select distinct city from station where NOT (REGEXP_LIKE(SUBSTR(CITY, 1, 1), '^[AEIOUaeiou]') AND REGEXP_LIKE(SUBSTR(CITY, -1, 1), '[AEIOUaeiou]$')) order by city;
The solution pass the test but In my solutions i have several problems :
return this results and i dont understand why:
Addison Agency Alanson Albany Albion Algonac Allerton Alton Andover Anthony Arlington Arrowsmith Athens Auburn