Previous Order Comparison

Show every order and the previous order amount in chronological order. Return columns: id, order_date, total_amount, previous_amount. Order results by: order_date, id) AS previous_amount FROM orders ORDER BY order_date, id.