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

with
    t1 as (
        select
            department_name,
            avg(performance_score) as avg_performance_score
        from
            employee_projects
            join department_info using (employee_id)
        group by
            department_name
    )
select
    employee_id,
    t1.department_name,
    performance_score
from
    employee_projects
    join department_info using (employee_id)
    join t1 using (department_name)
where
    performance_score > avg_performance_score
order by
    employee_id asc;