<s>[INST] Write a SQL code to find the total revenue generated from orders before any discounts or subsidies were applied.  [/INST] SELECT SUM(order_delivery_original_amt) AS total_revenue FROM order_transaction.transaction_detail_deprecated; </s>