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

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

separator="," open="(" close=")">

#{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)