数据求和显示，求大神指导。

;with m as (
-- 下面是你原来的
select DepartmentName,
       SectionOffice,
       (select count(*) ShareCount
          from tblTaskFlowRecord
         where OperationType in (2, 3)
           and CreateWechatOpenId = c.OpenId
         group by CreateWechatOpenId) ShareCount --分享量
  from (select distinct CreateWechatOpenId from tblTaskFlowRecord) a
  join SysUser c
    on a.CreateWechatOpenId = c.OpenId
  left join tblDepartmentRelation d
    on c.Mobile = d.Phone
-- 上面是你原来的
)
,cte AS (
   select
       ROW_NUMBER() OVER (ORDER BY DepartmentName) AS rid,
        DepartmentName,
       SectionOffice,
       sum(ShareCount) ShareCount
  from m
  group by
       DepartmentName,
       SectionOffice
)
SELECT * FROM cte where rowNumber BETWEEN 1 AND 20