It's Autumn! Prices fall like leaves! - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
ROWS
12. Abbreviations – exercise
RANGE
Default window frame
Summary

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.