title: SQL Select COUNT(Value=Value) Possible?
body: <p>I want to Count all the rows that only have the value I want like this:</p>
  
  <pre><code>SELECT Users.Balance,
         Users.FreeBids,
         COUNT(Bids.Burned = 0) AS 'ActiveBids',
         COUNT(Bids.Burned = 1) AS 'BurnedBids'
  FROM   Users
         INNER JOIN Bids
           ON Users.ID = Bids.BidderID
  WHERE  Users.ID = 2
  GROUP  BY Users.Balance,
            Users.FreeBids  
  </code></pre>
  
  <p>It says "<code>Invalid Syntax Neat '='</code> It works perfectly without the '='.
  How can I count the rows that Burned=1 in them and Burned=0 in them?</p>
  
  <p>Thanks,
  Dan</p>