对符合条件的数据统计个数

select   max(m.check_score) as jcmax , min(m.check_score)  as jcmin ,avg(m.check_score) as jcavg ,count(*) as jccount ,sum( case  when m.check_score >=80 then 1 else 0 end) as jcdbs
		, max(m.self_score) as zcmax , min(m.self_score)  as zcmin ,avg(m.self_score) as zcavg ,count(*) as zccount ,sum( case  when m.self_score >=80 then 1 else 0 end) as zcdbs
		from tb_report_anfang_result m,
		(select max(create_time) as create_time , dept_id from tb_report_anfang_result r where r.dept_id in
		
			#{item.deptId}
		
		and   to_days(r.create_time)  to_days(#{datetime}) group by r.dept_id ) as temp
		where m.create_time = temp.create_time and m.dept_id = temp.dept_id

 

select count(*) as rys ,
sum( case  when binglileixing  = "XX人员"  then 1 else 0 end) as mjry ,  
sum( case  when isMeetCondition  = 1  then 1 else 0 end) as glqwmry  ,
sum( case  when photourl  is not null   then 1 else 0 end) as xczm
 from fgtb_tianbao  where lid in (76,77)