题解 | 查找在职员工自入职以来的薪水涨幅情况
#我这个代码可以运行，输出的结果也是一样，但是不知道为什么在这个平台上无法提交成功
select
employees.emp_no,
max(salaries.salary) -min(salaries.salary) as growth
from employees
left join salaries
on employees.emp_no = salaries.emp_no
where salaries.to_date <= '9999-01-01'
group by employees.emp_no
having growth != 0
order by growth desc
;
查看25道真题和解析