统计各个区的需求

```sql
select ll.deptname, count(1) as shuliang
from (select d.no,
d.title,
d.status,
b.name,
b.id,
c.name,
(select g.name
from epmuser.epm_group g
where g.id = a.group_id) deptname
from epmuser.epm_group_user a,
epmuser.epm_user b,
epmuser.epm_project c,
epmuser.epm_problem d
where a.user_id = b.id
and b.id = c.manager
and c.product_id = 22
and d.source_id = c.id
and d.status in (3)
and a.group_id in (select zz.id
from epmuser.epm_group zz
where zz.parent in (355, 350))) ll
group by ll.deptname;
```

每月各区提交的需求：
```sql
select ll.deptname, count(1) as shuliang
from (select d.no,
d.title,
d.status,
b.name,
b.id,
c.name,
(select g.name
from epmuser.epm_group g
where g.id = a.group_id) deptname
from epmuser.epm_group_user a,
epmuser.epm_user b,
epmuser.epm_project c,
epmuser.epm_problem d
where a.user_id = b.id
and b.id = c.manager
and c.product_id = 22
and d.source_id = c.id
and a.group_id in (select zz.id
from epmuser.epm_group zz
where zz.parent in (355, 350))
and d.created_at >= to_date(‘2021-05-01’, ‘yyyy-mm-dd’)
and d.created_at <= to_date(‘2021-06-01’, ‘yyyy-mm-dd’)) ll
group by ll.deptname;
```