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

with t1 as
(
    select
    project_id
    ,round(avg(performance_score),2) avg_performance_score
from employee_projects
group by 1
)
select
    e.employee_id
    ,department_name
    ,performance_score
from employee_projects e
join department_info d on e.employee_id = d.employee_id
join t1 on e.project_id = t1.project_id
where performance_score > avg_performance_score
group by 1
order by 1;