SELECT employee id, first name, last name, salary, (salary - (SELECT AVG(salary) FROM employees)) AS salary difference FROM employees;