我的理解是一年的涨幅应该是同一年内的涨幅,例如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