select distinct tbl_sales.dept_code, dept_name
from tbl_dept
right join tbl_orders on tbl_orders.dept_code = tbl_dept.dept_code 
right join tbl_sales on tbl_sales.dept_code = tbl_dept.dept_code
order by 1 ;