Introduction
ROWS
12. Abbreviations - exercise
RANGE
Default window frame
Revision

Instruction

Fine. Let's do one more exercise

Exercise

For each single_order, show its placed date, total_price and the average price from the current single_order and three previous orders (in terms of the placed date).

Stuck? Here's a hint!

Use ROWS BETWEEN 3 PRECEDING AND CURRENT ROW.

Console

Code editor

Result

TableConsole