题解 | 查询员工薪资>manager_salary

select 
dee.emp_no,
dem.emp_no as manager_no ,
es.salary as emp_salary,
ms.salary as manager_salary 
from 
dept_emp as dee join dept_manager as dem on dee.dept_no=dem.dept_no 
left join salaries as es on dee.emp_no=es.emp_no
left join salaries as ms on dem.emp_no= ms.emp_no
where dee.emp_no<> dem.emp_no
and es.salary>ms.salary;