Using the orders table, calculate the average order amount of the current, 1 preceding, and 1 following orders for each user. Do the calculation based on the order_id in ascending order.

Let's go through an example:

buyer_id 101 had 5 orders, for each row, you want to calculate the average order_amount of the row prior until next row. If we look at the second row, user_id, 101 spent $75.

We want to average the value prior ($120), the value after that row ($140) and the current row ($75). And do that across each row of the orders table.

orders table:

Example Output: