title: SQL When a result has two rows of output, how can I sum them?
body: <p>I have this query below:</p>
  
  <pre><code>Select
  count(CDT) as Actions
  From Player_Tapjoy
  Where
  Trunc(CDT) &gt;= To_Date('2012-sep-01','yyyy-mon-dd')
  And Trunc(CDT) &lt; To_Date('2012-sep-12','yyyy-mon-dd')
  Union All
  Select 
  Count(CDT) As Actions
  From Player_aux_pt
  Where
  Site = 'AppCircle' And
  Trunc(CDT) &gt;= To_Date('2012-sep-01','yyyy-mon-dd')
  And Trunc(CDT) &lt; To_Date('2012-sep-12','yyyy-mon-dd')
  </code></pre>
  
  <p>This output gives me two rows, one for each of the select functions. How can I combine these to get the sum of the two select functions? And on top of that, how do I group it by CDT (the date)?</p>