统计

select a.dept, b.num from vzdbm a,(
select count(employeeid) num,dept  from s_tempemployeeinfo_386  e,vzdbm d
where e.ordernum is not null and e.departmentid(+) =d.dept
group by d.dept  ) b where a.dept = b.dept(+) order by a.dept