case when语句运用

 select b.cur_branch,

 count(p.conttract_id),

 sum(case when p.aff_date is null then p.payable_money else 0 end),

 sum(case when p.aff_date is null and p.fee_item ='租金' then p.payable_money else 0 end),

 sum(case when p.aff_date is null and p.fee_item ='电费' then p.payable_money else 0 end),

 sum(case when p.aff_date is not null then 1 else 0 end),

 sum(case when p.aff_date is null then 1 else 0 end)

 from WG_PJHSB p, wg_jzmb b

 where p.station_id = b.station_code

 group by b.cur_branch

 order by b.cur_branch