Count the number of orders for each unique payment method id.

SELECT order_payment_method_id, COUNT(*) AS total_orders
FROM order_transaction.transaction_detail_deprecated
GROUP BY order_payment_method_id;