LAG Function

LAG(column, offset) returns the value from a previous row:

LAG(amount, 1) OVER(ORDER BY date) -- previous row's amount
LAG(amount, 2) OVER(ORDER BY date) -- 2 rows back

Default offset is 1 if not specified.

Your Task

For each payment, show:

• paidAt, amount
• The previous payment's amount (as prev_amount)
• The difference from previous (as change_from_prev)

Order by paidAt, limit to 10.