with
    details as (
        select
            e.employee_id,
            department_name,
            performance_score,
            avg(performance_score) over(partition by department_name) as avg_performance_score
        from
            employee_projects e
            join department_info d on e.employee_id = d.employee_id
    )

select employee_id
,department_name
,performance_score
from details d
where performance_score > avg_performance_score
order by employee_id