SQL Practice Logo

SQLPractice Online

Scenario SQL Question

Running Total of Salaries by Department

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

Problem Statement

Calculate a running total of salaries within each department ordered by hire date. Show employee name, hire date, salary, department name, and running total.

Relevant Tables

employeesdepartments