题解 | #统计出当前各个title类型对应的员工当前薪水对应的平均工资#

单表自连接,没啥思路,就恩做,表1也没用到.我是不是很呆

select s1.emp_no,sum(s2.salary-s1.salary) as growth
from salaries s1 join salaries s2
on s1.to_date= s2.from_date 
group by s1.emp_no
having s1.emp_no in (
    select emp_no 
    from salaries 
    where to_date='9999-01-01')
order by growth