34,838
社区成员




select sum(case when bonus = 0 then 1 else 0) as No_Bonus_Cnt,
sum(case when bonus > 0 then 1 else 0) as Has_Bonus_Cnt
from table_1;
select 单位名称,
sum(case when 本月奖金 > 0 then 1 else 0 end) '得奖人数',
sum(case when 本月奖金 = 0 then 1 else 0 end) '没得奖人数'
from tb
group by 单位名称