SQL Practice Logo

SQLPractice Online

Scenario SQL Question

Delta From Starting Salary (FIRST_VALUE)

Build mastery in Ctes Window with this scenario-based SQL challenge and live execution support.

Problem Statement

For each salaries_history record, show how far the salary has moved from the employee's very first recorded salary. Return employee_id, effective_date, salary, starting_salary, delta_from_start — ordered by employee_id, effective_date.

Relevant Tables

salaries_history

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics: