select 雇员编号,max(薪水)-min(薪水) as 薪水涨幅 from 薪水表
group by 雇员编号
having max(结束日期) = '2004-01-01'