select bureau_id,cust_name,sum(temp1),sum(temp2),sum(temp1)/sum(temp2)*100 from
(select bureau_id,cust_name,count(acc_nbr) as temp1,0 temp2 from wm_200701mon
where type= '201电话 ' and card_charge=0
group by bureau_id,cust_name
union all
select bureau_id,cust_name,0 temp1,count(acc_nbr) as temp2 from wm_200701mon
where type= '201电话 '
group by bureau_id,cust_name
)
group by bureau_id,cust_name
;
我只是想得到一个card_charge为0的占比报表,帮帮我,谢谢!
------解决方案--------------------
select bureau_id,cust_name,temp1=sum(case when card_charge=0 then count(acc_nbr) else 0 end),temp2=sum(case when card_charge=0 then 0 else count(acc_nbr) end),temp3=sum(case when card_charge=0 then count(acc_nbr) else 0 end)/sum(case when card_charge=0 then 0 else count(acc_nbr) end)*100
from wm_200701mon where type= '201电话 ' group by bureau_id,cust_name