Problem Statement

For each employee, ordered by hire_date within their department, show the previous and next hired employee's salary, plus the salary change vs the previous hire. Return department_name, first_name, last_name, hire_date, salary, prev_emp_salary, next_emp_salary, salary_change — ordered by department_name, hire_date, employee_id.

Relevant Tables