title: SQL query count customers
body: <p>I need count how many suppliers have status &quot;<em>CLOSED</em>&quot; or &quot;<em>READY FOR AUDIT</em>&quot;, but in the same time I don't want to count those suppliers that have status &quot;NULL&quot;.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>supplier</th>
  <th>status</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>JUSTRITE MANUFACTURING COMPANY</td>
  <td>CLOSED</td>
  </tr>
  <tr>
  <td>JW SPEAKER CORPORATION</td>
  <td>CLOSED</td>
  </tr>
  <tr>
  <td>KLEIN TOOLS INC</td>
  <td>NULL</td>
  </tr>
  <tr>
  <td>KLEIN TOOLS INC</td>
  <td>CLOSED</td>
  </tr>
  <tr>
  <td>KLEVER INNOVATIONS</td>
  <td>CLOSED</td>
  </tr>
  <tr>
  <td>LA-CO INDUSTRIES INC</td>
  <td>CLOSED</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>As we can see in this example, there are 5 different customers, but the results will be &quot;4&quot; because <code>KLEINT</code> contains &quot;NULL&quot; and it shouldn't be counted in.</p>