title: SQL Query: How to show the opposite result of your query in select statement
body: <p>Im a lil bit stuck here, really hope somebody could help me out.
  I couldn't found yet the answer from google.</p>
  
  <p>Ok let say the data is like below:</p>
  
  <pre><code>TableName=&gt; Events
  
  | Node_Name| Status    |
  +----------+-----------+
  | Node_1   | Completed |
  | Node_1   | Completed |
  | Node_2   | Failed    |
  | Node_2   | Completed |
  | Node_3   | Failed    |
  | Node_3   | Failed    |
  </code></pre>
  
  <p>Query: </p>
  
  <pre><code>select node_name, count(*)
  from events
  where status='Failed'
  group by node_name
  </code></pre>
  
  <p>Result:</p>
  
  <pre><code>| Node_2 | 1 |
  | Node_3 | 2 |
  </code></pre>
  
  <p>The question is, how can i group a node_name that never "failed" and always completed.</p>
  
  <p>Query: ?????????</p>
  
  <p>Result that I wanted:</p>
  
  <pre><code>=&gt;Node_1
  </code></pre>
  
  <p>Really appreciate your help.</p>
  
  <p>Thank you!</p>