17,086
社区成员
发帖
与我相关
我的任务
分享
select case max(b.area) when 1 then max(b.name)
else max(c.name) end name,
count(decode(a.state,0,1))状态0数量,
count(decode(a.state,1,1))状态1数量,
count(decode(a.state,2,1))状态2数量,
count(decode(a.state,3,1))状态3数量
from aa a inner join bb b
inner join (select name,area from bb where fid=-100)c
on a.cid=b.cid and b.area=c.area
group by decode(b.area,1,b.name,b.area)
order by name