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

# 查询每个部门中绩效得分高于部门平均绩效得分的员工信息
with
t1 as(
    select
        employee_id,
        department_name,
        performance_score,
        avg(performance_score)over(partition by department_name) as davg
    from
        employee_projects left join department_info using(employee_id)
)
,
t2 as(
    select
        employee_id,
        department_name,
        performance_score
    from
        t1
    where
        performance_score>davg
    order by
        employee_id
)

select * from t2