题解 | 分析每个员工在不同项目中的绩效情况

select 
    e.employee_id,
    e.employee_name,
    p.performance_score as first_half_2024_score,
    row_number() over(partition by ps.project_name order by p.performance_score desc, e.employee_id) as project_group_rank,
    e.department,
    ps.project_name as project_group
    from employees e 
    inner join performance p 
    on p.employee_id = e.employee_id
    inner join projects ps 
    on ps.project_id = p.project_id
    WHERE
    ps.start_date BETWEEN '2024-01-01' AND '2024-06-30'
    ORDER BY ps.project_id ASC,project_group_rank ASC