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

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

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;

全部评论

相关推荐

评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客网在线编程
牛客网题解
牛客企业服务