title: SQL - How to count yes and no items
body: <p>I am using SQL Server 2008.</p>
  
  <p>I am writing a query where I need to count how many yesses (1) and how many nos (0 or NULL).</p>
  
  <pre><code>SELECT B.Brand, B.BrandID, COUNT(M.ModelID) AS TotalModels
  FROM Brands B LEFT JOIN Models M ON B.BrandID = M.BrandID
  GROUP BY B.Brand, B.BrandID
  ORDER BY B.Brand
  </code></pre>
  
  <p>There's another field called IsBestValue in the Model table that will be NULL, 0, or 1.  I want to be able to count TotalBestValueYes, TotalBestValueNo, and TotalBestValueNULL.</p>
  
  <p>A long time ago...I use to use something like ..</p>
  
  <pre><code>(CASE WHEN IsBestValue = 1 END) // ADD ONE TO TotalBestValueYes
  (CASE WHEN IsBestValue = 0 END) // ADD ONE TO TotalBestValueNo
  (CASE WHEN IsBestValue = NULL END) // ADD ONE TO TotalBestValueNULL
  </code></pre>
  
  <p>Is using CASE in the fashion a good idea? Bad idea? Overkill? </p>
  
  <p>Is there are better way to count yesses and nos and NULLs?</p>