7,712
社区成员
发帖
与我相关
我的任务
分享
select name,count(*),sum(iif(audit=0,1,0)), sum(iif(audit=1,1,0)),sum(iif(audit=2,1,0))
from test
group by name
select 姓名,count(*),
sum(iif(状态=0,1,0)) as 状态0,
sum(iif(状态=1,1,0)) as 状态1,
sum(iif(状态=2,1,0)) as 状态2
from table1
group by 姓名