SELECT first_name,

last_name,

salary,

avg(salary) over()

from employee 

where department_id in (1,2,3)