SQL Practice Logo

SQLPractice Online

Scenario SQL Question

Find Consecutive Employees with Increasing Salaries

Build mastery in Ranking Nth Value with this scenario-based SQL challenge and live execution support.

Problem Statement

Write a query to find groups of consecutive employees (by hire_date) with increasing salaries. Show employee names, hire_date, salary, and salary_diff from previous employee.

Relevant Tables

employees

SQL Concepts Used in This Scenario

Strengthen your understanding with these targeted learning topics: