MySQL给员工加工资_给出每个员工每年薪水涨幅超过5000的员工编号emp_no

我的理解是一年的涨幅应该是同一年内的涨幅，例如2017年年初和年末同一个人的工资涨幅大于5000，即可满足，看了讨论不是很赞同高赞观点。下面给出我这种理解的sql

select A.emp_no as emp_no,A.from_date as from_date,(B.salary-A.salary) as salary_growth

from (

select emp_no,from_date,salary,strftime("%Y",from_date) as yearbegan

from salaries

group by emp_no,strftime("%Y",from_date)

having from_date=min(from_date) ) as A

inner join (

select emp_no,from_date,salary,strftime("Y",from_date) as yearend

from salaries

group by emp_no,strftime("Y",from_date)

having from_date=max(from_date) ) as B

on A.emp_no=B.emp_no and A.yearbegan=B.yearend

where B.salary-A.salary>5000

order by (B.salary-A.salary) desc