Introduction
ROWS
12. Abbreviations – exercise
RANGE
Default window frame
Summary

Instruction

Great! Let's do a practice exercise.

Exercise

For each SingleOrder, show its PlacedDate, TotalPrice and the average price (calculated from the current SingleOrder and the three previous orders in terms of the PlacedDate). Name the column AvgTotalPrice.

Stuck? Here's a hint!

Use ROWS 3 PRECEDING.