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

SELECT
    e.employee_id,
    e.employee_name,
    pf.performance_score AS first_half_2024_score,
    ROW_NUMBER() OVER (PARTITION BY pj.project_id ORDER BY  pf.performance_score DESC,e.employee_id ASC) AS project_group_rank,
    e.department,
    pj.project_name AS project_group
FROM 
    employees AS e
    INNER JOIN
    performance AS pf ON e.employee_id=pf.employee_id
    INNER JOIN
    projects AS pj ON pf.project_id=pj.project_id
WHERE
    pj.start_date BETWEEN '2024-01-01' AND '2024-07-01'
ORDER BY
    pj.project_id,
    project_group_rank,
    e.employee_id;