title: Count records by group with 0 number for records out of criteria
body: <p>Need a rope ;)) Take a look on example:</p>
  
  <p>I have a table:</p>
  
  <pre><code>CREATE TABLE [dbo].[test3](
      [software] [varchar](50) NOT NULL,
      [result] [bit] NOT NULL,
      [computername] [varchar](50) NOT NULL
  ) 
  </code></pre>
  
  <p>With data:</p>
  
  <pre><code>INSERT INTO test3 VALUES ('Adobe',1,'abc')
  INSERT INTO test3 VALUES ('Office',1,'abc')
  INSERT INTO test3 VALUES ('Adobe',0,'def')
  INSERT INTO test3 VALUES ('Office',1,'def')
  </code></pre>
  
  <p>So after ordinary SELECT we have:</p>
  
  <pre><code>software                                           result computername
  Office                                             1      abc
  Adobe                                              1      abc
  Office                                             1      123
  Adobe                                              0      123
  </code></pre>
  
  <p>An NOW, my question. I would like to count Software quantity by software group. The "Result" column means: 0 not installed, 1 installed.</p>
  
  <p>To count all installed (result=1) I can do simple:</p>
  
  <pre><code>SELECT
      Software
      ,COUNT(*) as Quantity
  FROM
      test3
  WHERE
      result = 1
  GROUP BY
      software
  </code></pre>
  
  <p>BUT if I want to "reverse" the result and count how many computers from table have not software installed  (result = 0) I will not see a results which I needs (for report).</p>
  
  <p>After that:</p>
  
  <pre><code>SELECT
      Software
      ,COUNT(*) as Quantity
  FROM
      test3
  WHERE
      result = 0
  GROUP BY
      software
  </code></pre>
  
  <p>I will get:</p>
  
  <pre><code>Software                                           Quantity
  -------------------------------------------------- -----------
  Adobe                                              1
  </code></pre>
  
  <p>Which means: "Only 1 Adobe is missed and rest of software is installed everywhere".</p>
  
  <p>But I need for good look of report something like that:</p>
  
  <pre><code>Software                                           Quantity
  -------------------------------------------------- -----------
  Adobe                                              1
  Office                                             0
  </code></pre>
  
  <p>Which means ;) "Only 1 Adobe installation is missed and 0 Office installation is missed."</p>
  
  <p>I'm stuck with that :/ Plz help :)</p>