#查询每个部门中绩效得分高于该部门平均绩效得分的员工信息。查询出来的数据按照员工 ID 升序排列
select employee_id,department_name,performance_score
from(
    select a.employee_id,department_name,performance_score,
            avg(performance_score)over(partition by department_name) as avg_score
    from employee_projects as a
    inner join department_info as b
    on a.employee_id = b.employee_id
) as temp1
where performance_score >= avg_score
order by employee_id