title: Complex agregation in T-SQL
body: <p>For example I have a table in MS SQL Server:</p>
  
  <pre><code>Feature, Option1, Option2
  -------------------------
  Agent, Yes, No
  Agent, No, No
  Console, No, Yes,
  Console, Yes, Yes
  </code></pre>
  
  <p>I need to write a query that returns:</p>
  
  <pre><code>Feature, Option1 Yes Count, Option2 Yes Count
  ---------------------------------
  Agent, 1, 0
  Console, 1, 2
  </code></pre>
  
  <p>What query should I use?</p>