题解 | 分析员工在不同项目中的绩效表现以及所属部门的平均绩效情况
分析员工在不同项目中的绩效表现以及所属部门的平均绩效情况
https://www.nowcoder.com/practice/20c76a1181004965a3106524fd3ab583
select employee_id,
department_name,
performance_score
from employee_projects e
join department_info d using (employee_id)
where performance_score>(
select avg(performance_score)
from employee_projects
)
