求助SQL大神，拜托啦各位（Oracle），在线等，急！！！！

Question

表decla_regularInfo，其中一些字段，
id ，
declarCycle 年度，
declarYear 报告年度
DeclarType 申报类型
dataStatus 完成状态 (1待提交、2待审核、3审核通过、4待修改)；
怎么一条SQL实现这样形式

解释一下：其中
审核通过就是 完成状态 3，
已申报人数就是 完成状态 2 3 4

Answer 1

select t2.declarCycle as 年度,
t2.declarYear as 报告年度,
t2.DeclarType as 申报类型,
count(1) as 应申报人数,
(select count(1)
from decla_regularInfo t1
where t1.declarCycle = t2.declarCycle
and t1.DeclarType = t2.DeclarType
and t1.declaryear = t2.declaryear
and t1.dataStatus = '1') as 审核通过,
(select count(1)
from decla_regularInfo t3
where t3.declarCycle = t2.declarCycle
and t3.DeclarType = t2.DeclarType
and t3.declaryear = t2.declaryear
and t3.dataStatus in ('2', '3', '4')) as 已申报人数
from decla_regularInfo t2
group by t2.declaryear, t2.declarCycle, t2.DeclarType
order by declarCycle, DeclarType;