获取工资比其部门经理还高的员工信息

select a.emp_no,
       b.emp_no manager_no,
       c.salary emp_salary,
       d.salary manager_salary
  from dept_emp a inner join
       dept_manager b on a.dept_no = b.dept_no inner join 
       salaries c on a.emp_no = c.emp_no inner join 
       salaries d on b.emp_no = d.emp_no
 where c.salary > d.salary