给出每个员工每年薪水涨幅超过5000的员工
给出每个员工每年薪水涨幅超过5000的员工编号emp_no
http://www.nowcoder.com/questionTerminal/eb9b13e5257744db8265aa73de04fd44
select s1.emp_no, s1.from_date, (s1.salary - s2.salary) as salary_growth
from salaries s1, salaries s2
where s1.emp_no = s2.emp_no and s1.from_date = s2.to_date
and (s1.salary - s2.salary) > 5000
order by salary_growth desc;