Above-Average Earners Via A CTE

Using a CTE that computes each department's average 'salary', return the employee 'name', their department 'name' as 'department', and 'salary' for employees earning above their department average.