title: SQL (DB2) Return multiple conditional counts in a single query
body: <p>I am trying select multiple conditional summaries into a single table result on a DB2 based database. </p>
  
  <p>Example:</p>
  
  <pre><code>SELECT COUNT(FOO) FROM T1 WHERE T1.A=1 AS A_COUNT,
  SELECT COUNT(FOO) FROM T1 WHERE T1.B=2 AS B_COUNT
  Ext...
  </code></pre>
  
  <p>Any help is appreciated. </p>