with t as (

select e.department_id

, e.salary

from employees e

)

select *

from t

pivot

(

avg(salary)

for department_id

in (

10, 20, 60, 110

)

);