题解 | #统计各个部门的工资记录数#
获取员工其当前的薪水比其manager当前薪水还高的相关信息
http://www.nowcoder.com/practice/f858d74a030e48da8e0f69e21be63bef
select emps.emp_no, mans.emp_no, emps.salary, mans.salary
from (select dept_emp.emp_no,salaries.salary salary, dept_emp.dept_no dept_no
from dept_emp join salaries on dept_emp.emp_no=salaries.emp_no) as emps
left join
(select dept_manager.emp_no, salaries.salary salary, dept_manager.dept_no dept_no
from dept_manager join salaries on dept_manager.emp_no=salaries.emp_no) as mans
on emps.dept_no=mans.dept_no
where emps.salary>mans.salary
from (select dept_emp.emp_no,salaries.salary salary, dept_emp.dept_no dept_no
from dept_emp join salaries on dept_emp.emp_no=salaries.emp_no) as emps
left join
(select dept_manager.emp_no, salaries.salary salary, dept_manager.dept_no dept_no
from dept_manager join salaries on dept_manager.emp_no=salaries.emp_no) as mans
on emps.dept_no=mans.dept_no
where emps.salary>mans.salary