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

select
    employee_id,
    employee_name,
    performance_score as first_half_2024_score,
   row_number() over (
        partition by
            project_id
        order by
            performance_score DESC,employee_id
    ) as project_group_rank,
    department,
    project_name as project_group
from
    performance
    join projects using (project_id)
    join employees using (employee_id)
where
    start_date between ' 2024-01-01' and '2024-07-01'
order by project_id,project_group_rank,employee_id

    

这题目难度应该属于简单级别，另外题目的排名依据应该大大方方写清楚，别藏到结果解释里面，做题时候真的很烦一些语文表达严重不及格的出题条件