题解 | 分析员工在不同项目中的绩效表现以及所属部门的平均绩效情况
分析员工在不同项目中的绩效表现以及所属部门的平均绩效情况
https://www.nowcoder.com/practice/20c76a1181004965a3106524fd3ab583
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;