LAG() for Comparisons

Problem

The CFO is analyzing historical pay raises and wants to see how each new hire's starting salary compared to the person hired immediately before them. Return each employee's first_name, salary, and the salary of the employee hired immediately before them (ordered by hire_date). Name it prev_salary.

Database Schema

Table: employees

• employee_id (INT): Unique identifier for the employee.
• first_name (VARCHAR): First name of the employee.
• last_name (VARCHAR): Last name of the employee.
• salary (INT): Employee's salary.
• department_id (INT): Foreign key referencing the department.
• manager_id (INT): Foreign key referencing the manager (another employee).
• hire_date (DATE): Date the employee was hired.

Table: departments

• department_id (INT): Unique identifier for the department.
• department_name (VARCHAR): Name of the department.

Try It

Hint

Solution