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

select
    e.employee_id,
    employee_name,
    performance_score first_half_2024_score,
    row_number() over(partition by pr.project_id order by performance_score desc, e.employee_id) project_group_rank,
    department,
    project_name project_group
from
    employees e 
left join performance pe on e.employee_id=pe.employee_id
left join projects pr on pr.project_id=pe.project_id
where start_date between "2024-01-01" and '2024-07-01'
# group by e.employee_id, employee_name, department, project_name 
order by pr.project_id, project_group_rank, e.employee_id