Introduction
ROWS
RANGE
Default window frame
Revision
23. Exercise 1

Instruction

Let's start with the first question!

Exercise

For each row from department with id = 2, show its department_id, year, amount and the total amount from the current year + two previous years.

Console

Code editor

Result

TableConsole