题解 | 分析员工在不同项目中的绩效表现以及所属部门的平均绩效情况

with t as (
    select project_id, avg(performance_score) as avg_score
    from employee_projects
    group by project_id
)
select temp.employee_id, department_name, performance_score
from (
    select employee_id, performance_score
    from employee_projects emp join t on emp.project_id=t.project_id
    where emp.performance_score>t.avg_score
) temp join department_info dep on temp.employee_id=dep.employee_id