title: SQL Same column subtraction
body: <p>How could I get this query to be in the correct syntax? (MySQL)</p>
  
  <p>Thank you.</p>
  
  <pre><code>SELECT (count(a) WHERE a = 1)-(count(a) WHERE a = 0) FROM table
  </code></pre>