<s>[INST] Write a SQL code to determine the total discount amount applied to Direct Delivery (DD) orders.  [/INST] SELECT SUM(order_firstdateofweek) AS total_discount_amount_dd_orders FROM order_transaction.transaction_detail_deprecated; </s>