牛客SQL3--查找当前薪水详情以及部门编号dept_no

MYSQL:

select salaries.*,dept_manager.dept_no 
from salaries join dept_manager
on salaries.emp_no=dept_manager.emp_no
order by salaries.emp_no;