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

select a.employee_id, employee_name, performance_score as first_half_2024_score,
row_number() over (partition by project_name order by performance_score desc, a.employee_id) as project_group_rank,
department, project_name as project_group
from performance a
join employees b on a.employee_id=b.employee_id
join (
    select * 
    from projects 
    where start_date>='2024-01-01' and start_date<='2024-07-01'
) c on a.project_id=c.project_id
order by a.project_id, performance_score desc, a.employee_id