业绩统计

 

算出该表的业绩统计

 

区域

现付票数

现付金额

月结票数

到付票数

到付80%

月结金额

总票数

总金额

备注

 

select  areano, dfps = count(case when PayType='到付' then (PayType ) end ), dfje = sum(case when PayType='到付' then (AmountRMB ) end) * 0.8,  yjje = sum(case when PayType='月结' then AmountRMB end),yjps = count(case when PayType='月结' then (PayType ) end ), xfje = sum(case when PayType='现付' then AmountRMB end),xfps = count(case when PayType='现付' then (PayType ) end ),  PayType,
count(PayType) zps, sum(AmountRMB) zje from bill_tab  group by areano,PayType  having (PayType='到付' or PayType='寄付')