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

SELECT s.*, d.dept_no FROM salaries s LEFT JOIN dept_manager d ON s.emp_no = d.emp_no WHERE s.to_date = '9999-01-01' AND d.to_date = '9999-01-01'