分类统计三种单据数量

公告  弹出

----------------------------------------分类统计三种单据数量、案卷包含 任务单状态为结束、待审核、待处理

SELECT count(*), TRecTel.TypeID AS typeid, torg.orgid,orgname
FROM TRecWork INNER JOIN
      TRecTel ON TRecWork.TelID = TRecTel.TelID LEFT OUTER JOIN
      TRecDeal ON TRecWork.WorkID = TRecDeal.WorkID inner join torg on substring(trecwork.orgid,1,3)=torg.orgid
WHERE ((TRecWork.WorkStateID = 3 OR
       TRecWork.WorkStateID = 8) AND 
      (TRecDeal.ResultTypeID = 1)
      and (TRecWork.SendTime between '2011-05-01 00:00:00' and '2011-05-30 00:00:59')) or
      ((TRecWork.WorkStateID = 2 OR
       TRecWork.WorkStateID = 5 OR
       TRecWork.WorkStateID = 6)
       and (TRecWork.SendTime between '2011-05-01 00:00:00' and '2011-05-30 00:00:59'))
group by TRecTel.typeid, torg.orgid, orgname order by torg.orgid

select count(telid), satisfactionid  from treccallback tcb
where  CallbackTime between '2011-05-01 00:00:00' and '2011-05-30 00:00:59'
group by telid,satisfactionid

------------------------------------回访单统计

select count(substring(orgid,1,3)), substring(orgid,1,3) from (select distinct(telid), orgid from trecwork
where telid in (select distinct(telid) from treccallback tcb
where  CallbackTime between '2011-05-01 00:00:00' and '2011-05-30 00:00:59')) as b
group by substring(orgid,1,3) order by substring(orgid,1,3)