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.
There are 2 things needs to be changed:
1) you have to use OR instead of AND
2) In the 2nd part of the query use substr(UPPER(CITY),-1,LENGTH(CITY)) NOT in ('A','E','I','O','U');
Instead of substr(UPPER(CITY),-1,1) NOT in ('A','E','I','O','U');
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 11
You are viewing a single comment's thread. Return to all comments →
There are 2 things needs to be changed: 1) you have to use OR instead of AND 2) In the 2nd part of the query use substr(UPPER(CITY),-1,LENGTH(CITY)) NOT in ('A','E','I','O','U'); Instead of substr(UPPER(CITY),-1,1) NOT in ('A','E','I','O','U');