title: Query the list of CITY names from STATION that do not start with vowels and do not end with vowels
body: <p>This is a challenge question from <a href="https://www.hackerrank.com/challenges/weather-observation-station-12/problem" rel="nofollow noreferrer">HackerRank</a>.</p>
  <p>My first query is working fine:</p>
  <pre><code>select distinct city
  from station
  where city not regexp '^[aeiou]'
  and   city not regexp '[aeiou]$'
  </code></pre>
  <p>But my second query is giving wrong answer</p>
  <pre><code>select distinct city
  from station
  where city not regexp '^[aeiouAEIOU].*[aeiouAEIOU]$'
  </code></pre>
  <p>It is compiling but giving wrong results</p>