select count(distinct empid), e.group_nm, d.date,
from emp e, dept_hist d 
where e.deptno = d.deptno
  and e.up_ts > sysdate -30
  and e.stat_cd between 100 and 200
  and e.group_nm like '%EMPNO%'
  and employee_id =1
  and e.employee_id = d.employee_id
group by group_nm,d.date;