title: selecting rows without using 'not in' clause
body: <p>I have a table like this:</p>
  
  <pre><code>+----+----------+
  | ID |    WA    |
  +----+----------+
  |124 | benefit  |
  |124 | ordane   |
  |124 | military |
  |124 | para     |
  |125 | benefit  |
  |126 | benefit  |
  |126 | ordane   |
  |127 | benefit  |
  |127 | ordane   |
  |127 | military |
  |128 | benefit  |
  +----+----------+
  </code></pre>
  
  <p>I wanted those ID's with WA = 'benefit' and  exclude those ID's with WA = 'ordane'.  I want to avoid <code>not in</code>, <code>not exists</code> and <code>except</code>.  I tried with <code>CASE</code> statement but didn't get it. Is there any other way? Thanks!</p>