--5. 查询工资高于平均工资的员工姓名、工资、所在部门名称。基于数据库

SELECT e.name, e.salary, d.name AS department
FROM employee e
JOIN department d ON e.department_id = d.id
WHERE e.salary > (SELECT AVG(salary) FROM employee)
ORDER BY e.salary DESC;