with tmp as(
select dept_code from TBL_ORDERS
intersect 
select dept_code from TBL_SALES)
select a.dept_code,
(select b.dept_name
   from tbl_dept b
  where b.dept_code = a.dept_code) as DEPT_NAME
  from tmp a
order by a.dept_code