Count the number of orders delivered to each unique delivery name.

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