数据库SQL实战（牛客网）: 给出每个员工每年薪水涨幅超过5000的员工编号emp_no

题目描述
给出每个员工每年薪水涨幅超过5000的员工编号emp_no、薪水变更开始日期from_date以及薪水涨幅值salary_growth，并按照salary_growth逆序排列。
提示：在sqlite中获取datetime时间对应的年份函数为strftime(’%Y’, to_date)

CREATE TABLE salaries (
emp_no int(11) NOT NULL,
salary int(11) NOT NULL,
from_date date NOT NULL,
to_date date NOT NULL,
PRIMARY KEY (emp_no,from_date));

select a.emp_no , a.from_date,(a.salary - b.salary) as salary_growth
from salaries as a join salaries as b 
on a.emp_no = b.emp_no and (strftime('%Y', a.to_date) - strftime('%Y', b.to_date) = 1)
and salary_growth > 5000
order by salary_growth desc;