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: