title: Sum the Count Visits - Sql
body: <p>I came across a scenario and I am confused on how I can get it to work.</p>
  
  <p>How can I <code>SUM</code> two different groups from the <code>COUNT</code> result?</p>
  
  <pre><code>Select Count(VisitID), Types 
  From Customers
  Group by Types;
  </code></pre>
  
  <p>Result gets to be like:</p>
  
  <pre><code>Type VisitID
  A    10
  B    20
  C    1
  </code></pre>
  
  <p>I want the result to be as follows:</p>
  
  <pre><code>Type VisitID
  A+C  11
  </code></pre>
  
  <p>Thanks.</p>