<s>[INST] Write a SQL code to calculate the average special discount applied to orders. [/INST] SELECT AVG(order_special_discount) AS average_special_discount FROM order_transaction.transaction_detail_deprecated; </s>