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)