title: SQL query to filter data by a specific column value with no deduplication
body: <p>I have a table in a clickhouse database that keeps track of items and their statuses. There can be multiple records with the same name. Each time a record is ingested it is given a status of either 0 or 1. A simplified version of the data  as follows:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>name</th>
  <th>status</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Obi</td>
  <td>0</td>
  </tr>
  <tr>
  <td>Obi</td>
  <td>0</td>
  </tr>
  <tr>
  <td>Harold</td>
  <td>0</td>
  </tr>
  <tr>
  <td>Harold</td>
  <td>1</td>
  </tr>
  <tr>
  <td>Ann</td>
  <td>0</td>
  </tr>
  <tr>
  <td>Ann</td>
  <td>1</td>
  </tr>
  <tr>
  <td>Lily</td>
  <td>0</td>
  </tr>
  <tr>
  <td>Lily</td>
  <td>0</td>
  </tr>
  <tr>
  <td>Lily</td>
  <td>0</td>
  </tr>
  <tr>
  <td>Ron</td>
  <td>0</td>
  </tr>
  <tr>
  <td>Ron</td>
  <td>1</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I only want to display the records that have never been given a status of 1, with no de-duplication. The values returned should be:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>name</th>
  <th>status</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>Obi</td>
  <td>0</td>
  </tr>
  <tr>
  <td>Obi</td>
  <td>0</td>
  </tr>
  <tr>
  <td>Lily</td>
  <td>0</td>
  </tr>
  <tr>
  <td>Lily</td>
  <td>0</td>
  </tr>
  <tr>
  <td>Lily</td>
  <td>0</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>What should the query look like in order to accomplish this?</p>
  <p>I have tried something like this, but it returns every record that has ever had a status of 0.</p>
  <pre><code>SELECT t.*
  FROM example_table t
  INNER JOIN
  (
      SELECT Name
      FROM example_table
      GROUP BY Name
  ) t2 ON t.Name = t2.Name
  WHERE t.findingStatus=0
  </code></pre>
  <p>I have tried variations of the above query but have not had any luck. I was thinking maybe an inner join where the left table has <code>status=0</code> and the right table where <code>status</code> has never been <code>0</code>. Not sure how to get that to work. Any help on this is much appreciated. Thanks!</p>