Debug: Incorrect LAG Ordering

Fix this query so previous amount is based on chronological order. SELECT user_id, event_date, amount, LAG(amount) OVER (PARTITION BY user_id ORDER BY amount) AS prev_amount FROM spend_events;

spend_events(user_id, event_date, amount)