题解 | #获取员工薪水比其manager薪水高的信息#
获取员工其当前的薪水比其manager当前薪水还高的相关信息
https://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
老黄牛耕田，一步一步
select
tmp1.*
from
(
select
tmp.*,
s1.salary as manager_salary
from
(
select
d.emp_no,
dm.emp_no as manager_no,
s.salary as emp_salary
from
dept_emp d
left join salaries s on d.emp_no = s.emp_no
left join dept_manager dm on d.dept_no = dm.dept_no
where
d.emp_no ! = dm.emp_no
) tmp
left join salaries s1 on tmp.manager_no = s1.emp_no
) tmp1
where
tmp1.emp_salary > tmp1.manager_salary
