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
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