title: Select all information from a table that has SOME status=0 in SQL
body: <p>I have the following table in MySQL database</p>
  
  <pre><code>account | status
  1       |   1
  1       |   0
  1       |   0
  2       |   0
  2       |   0
  2       |   0
  3       |   1
  3       |   1
  3       |   1
  </code></pre>
  
  <p>How do I SELECT from this table all information where some status for the account is equal to zero? In this example, the result should be </p>
  
  <pre><code>account | status
  1       |   1
  1       |   0
  1       |   0
  2       |   0
  2       |   0
  2       |   0
  </code></pre>
  
  <p>since for account.name=3 all statuses are 1. </p>
  
  <p>Thanks,
  Vladimir</p>