牛客 SQL：查找各个部门当前领导当前薪水详情以及其对应部门编号dept_no

题目：牛客 SQL3

代码：

SELECT salaries.emp_no, salaries.salary, salaries.from_date, salaries.to_date, dept_no 
FROM salaries INNER JOIN dept_manager
ON salaries.emp_no = dept_manager.emp_no
ORDER BY salaries.emp_no;