Problem Statement

For each employee ordered by hire date within their department, show their salary compared to the previous and next hired employee. Include employee name, hire date, salary, previous employee's salary, and next employee's salary.

Relevant Tables