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

with avg_score as (
select department_name,avg(performance_score) as avg_score
from department_info d
join employee_projects e on e.employee_id =d.employee_id
group by department_name
)
select d.employee_id,d.department_name,performance_score
from department_info d
join employee_projects e on e.employee_id =d.employee_id
join avg_score a on d.department_name=a.department_name
where performance_score>avg_score
order by  d.employee_id;