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

#查询出每个员工在 2024 年上半年的绩效总评分以及在不同部门的绩效排名。
#查询出来的数据按照项目ID升序排列，再按照在所属项目的绩效排名升序排列，排名一致的按照员工ID升序排列。
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 employees as a
left join performance as b
on a.employee_id = b.employee_id
left join projects as c
on b.project_id = c.project_id
where start_date between '2024-01-01' and '2024-06-30'
order by project_group,project_group_rank,a.employee_id