/*

 * 查询 employees 表中薪水大于 5000 的员工信息，

 * 并通过 INNER JOIN 与 departments 表连接，

 * 获取对应的部门名称。结果按员工的 last_name 排序。

 */

SELECT 

    e.employee_id, 

    e.first_name, 

    e.last_name, 

    d.department_name

FROM employees e

INNER JOIN departments d ON e.department_id = d.department_id

WHERE e.salary > 5000

ORDER BY e.last_name;

​