Find the Average salary deviation for an employee within department

I have a list of employees who work within a set of teams. We are trying to figure out for each year the difference for each employee’s salary to their department’s average. I have been looking at standard deviations but I’m a little stuck if I need to have a sub select to achieve this.

The table looks like:

I do not have any code to show because I always get stuck on aliases.