SQL Pattern: Previous Value

SELECT
    user_id,
    order_date,
    amount,

    LAG(amount) OVER (
        PARTITION BY user_id
        ORDER BY order_date
    ) AS previous_order_amount

FROM orders;