title: Find rows which have never satistifed a condition
body: <p>Say I have a table of customers with three possible statuses: loan default, open loan, paid in full.</p>
  <p>How can I find the customers who never defaulted?</p>
  <p>Example: John and Alex had multiple loans with different statuses.</p>
  <pre><code>id | customer | status
  ----------------------
  1     john     default
  1     john     open
  1     john     paid
  2     alex     open
  2     alex     paid
  </code></pre>
  <p>John defaulted once and Alex never defaulted. A simple <code>where status &lt;&gt; &quot;default&quot;</code> attempt doesn't work because it incorrectly includes John's non-defaulted cases. The result should give me:</p>
  <pre><code>id | customer
  -------------
  2     alex
  </code></pre>