Exercise

Using row based WINDOW functions

Window functions often take a row-based window, looking at a number of rows before or after the current row. In this exercise, you will use the same query three times to create a row based window function.

Instructions 1/3

undefined XP

1

2

3

Create a rolling average to find the average sale price of the item in the CURRENT row and the PRECEDING nine rows.

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}Exercise

Instructions 1/3

Exercise