title: Sql Query aggregate result
body: <p>I have a table with following data </p>
  
  <pre><code>AgentID     AgentName   ReportDate  LOBName SubAct  CountA  CountB
  ------------------------------------------------------------------    
  AgentSA1    Agent SA1   04/30/2020  SubActivity SA1     2   22
  AgentSA1    Agent SA1   04/30/2020  SubActivity SA2     2   11
  AgentSA1    Agent SA1   05/02/2020  SubActivity SA1     1    7
  AgentSA2    Agent SA2   04/30/2020  SubActivity SA1     2    6
  AgentSA2    Agent SA2   04/30/2020  SubActivity SA2     2    5
  AgentSA2    Agent SA2   05/02/2020  SubActivity SA2     1    3
  </code></pre>
  
  <p>and I want result something like..</p>
  
  <pre><code>AgentID     AgentName   ReportDate  LOBName SubAct  CountA  CountB  CalculatedClo
  ---------------------------------------------------------------------------------
  AgentSA1    Agent SA1   04/30/2020  SubActivity SA1     2       22      4
  AgentSA1    Agent SA1   04/30/2020  SubActivity SA2     2       11      4
  AgentSA1    Agent SA1   05/02/2020  SubActivity SA1     1        7      1
  AgentSA2    Agent SA2   04/30/2020  SubActivity SA1     2        6      4
  AgentSA2    Agent SA2   04/30/2020  SubActivity SA2     2        5      4
  AgentSA2    Agent SA2   05/02/2020  SubActivity SA2     1        3      1
  </code></pre>
  
  <p>Last column is the calculated one (<code>CalculatedClo</code>) which should have a calculation based on Group by Report Date and SubAct.  </p>
  
  <p>Can someone help me produce these values?</p>