此题与上题差不多。
select 
雇员编号,部门编号,薪水,
avg(薪水)over(partition by 部门编号) as 平均薪水
from 薪水表