title: Postgresql combine IN with NOT IN
body: <p>I have a table of entities where each can have different statuses. For the sake of keeping history, each status change is reflected by a new row.<br>
  Example:  </p>
  
  <pre class="lang-none prettyprint-override"><code>Entity Id      Status  
  123456         1    
  123456         2  
  789000         1  
  </code></pre>
  
  <p>Assuming i want to find all rows that have only status 1 (so if they have other statuses they should not be returned), How do I do that?</p>