SELECT first_name, last_name, salary, avg(salary) over() from employee where department_id in (1,2,3)