Window frames: running totals and moving averages · exercise 1 of 1 · free preview
A window has a frame: the rows it looks at for each row. ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW means from the first row up to this one, which makes a running total.
In order of hiring date, show name, hired_on and cumulative_salary: the total salary of everyone hired up to and including this employee. Use an explicit ROWS frame. Order by hired_on.
Tables in this practice company
departmentsemployees