服务人数-活动档案统计

## 服务人数统计
```SQL
select YEAR(diagnosisTime) 服务年份, count(1) 服务人次 
from admin_health_records hr
where hr.clinicId in (
  select clinic_id from sys_user u where u.del_flag = 0 and u.dept_id in(
	  select dept_id from sys_dept where dept_id = 1440536945641000 or FIND_IN_SET(1440536945641000, ancestors) and status = 0 and del_flag = 0
	)
) 
and hr.diagnosisTime >= '2020-01-01 00:00:00' and hr.diagnosisTime <= '2022-12-31 23:59:59'
group by YEAR(diagnosisTime)
```

## 活动档案统计
```SQL
select y 服务年份, count(1) 活动档案数 from 
(
  select distinct patientId, y from(
    select p.id patientId, year(p.createTime) y from admin_patient p where p.createBy in (
		  select user_id from sys_user u where u.del_flag = 0 and u.dept_id in(
			  select dept_id from sys_dept where dept_id = 1440536945641000 or FIND_IN_SET(1440536945641000, ancestors) and status = 0 and del_flag = 0
			)
		) 
		  and p.createTime >= '2020-01-01 00:00:00' and p.createTime <= '2020-03-31 23:59:59'
    union all 
		select patientId, YEAR(diagnosisTime) y from admin_health_records hr where clinicId in(
      select clinic_id from sys_user u where u.del_flag = 0 and u.dept_id in(
			  select dept_id from sys_dept where dept_id = 1440536945641000 or FIND_IN_SET(1440536945641000, ancestors) and status = 0 and del_flag = 0
			)
    ) 
		  and hr.diagnosisTime >= '2020-01-01 00:00:00' and hr.diagnosisTime <= '2020-03-31 23:59:59'
	) t
)t2
group by y

```