获取员工其当前的薪水比其manager当前薪水还高的相关信息

CREATE TABLE dept_emp(
emp_no INT PRIMARY KEY,
dept_no VARCHAR(8),
from_date date  ,
to_date date
)

INSERT into dept_emp VALUES(10001,'d001','1986-06-26','9999-01-01'),(10002,'d001','1986-08-03','9999-01-01')

CREATE TABLE dept_manager(
dept VARCHAR(8) PRIMARY KEY,
emp_no int ,
from_date date  ,
to_date date
)

INSERT into dept_manager VALUES('d001',10002,'1986-08-03','9999-01-01')

CREATE TABLE salaries(
emp_no int PRIMARY key,
salary int ,
from_date date  ,
to_date date
)

INSERT into salaries VALUES(10001,88958,'2002-06-22','9999-01-01'),(10002,72527,'1996-08-03','9999-01-01')

-- 先查员工
SELECT  de.emp_no,se.salary
from dept_emp de,salaries se 
WHERE de.emp_no = se.emp_no

-- 再查经理
SELECT dm.emp_no,sm.salary
FROM dept_manager dm,salaries sm 
WHERE dm.emp_no = sm.emp_no 

SELECT de.emp_no emp_no,dm.emp_no manager_no,se.salary emp_salary,sm.salary manager_salary
FROM dept_emp de,salaries se ,dept_manager dm,salaries sm 
WHERE de.emp_no = se.emp_no
and dm.emp_no = sm.emp_no 
and se.salary>sm.salary