题解 | 分析每个员工在不同项目中的绩效情况
分析每个员工在不同项目中的绩效情况
https://www.nowcoder.com/practice/fa64fd2eb40d4639bc23dfb1ffae2163
select
e.employee_id,
employee_name,
performance_score as first_half_2024_score,
row_number()over(
partition by pf.project_id
order by performance_score desc, pf.employee_id asc
) as project_group_rank,
department,
project_name as project_group
from
employees e
inner join performance pf on e.employee_id = pf.employee_id
inner join projects pj on pj.project_id = pf.project_id
where
start_date >= '2024-01-01'
and start_date <= '2024-07-01'
order by
pf.project_id asc,
project_group_rank asc,
e.employee_id asc;

