title: SUM() with a COUNT() statement
body: <p>I'm wondering if it is possible to sum specific values after a count statement.
  At the moment I have:</p>
  <pre><code>SELECT roles.Name AS Role_Name , COUNT(DISTINCT ur.UserId ) AS RoleCount FROM dbo.AbpUsers as users 
  LEFT JOIN resourcing.CompanyorganizationUnitUserRole AS ur on users.Id = ur.UserId
  LEFT JOIN dbo.AbpRoles AS roles ON roles.Id = ur.RoleId
  GROUP BY roles.Name;
  </code></pre>
  <p>Which outputs:</p>
  <pre><code>Role_Name:                    |RoleCount:
  TimeTrackingWritingMember     |8277
  OrganizationUnitLeader        |529
  Member                        |13901
  DepartmentalCoordinator       |759
  OrganizationUnitSecondLeader  |4
  ResourceCoordinator           |6
  
  </code></pre>
  <p>The idea is to SUM for example the roleCount of <strong>TimeTrackingWritingMember + Member = &quot;Basic User&quot;</strong></p>
  <p>I don't seem to get the logic how i could use both in one query. All help would be much appreciated</p>