Determine the total number of orders for each unique date partition.

SELECT order_date_partition, COUNT(*) AS total_orders_per_date_partition
FROM order_transaction.transaction_detail_deprecated
GROUP BY order_date_partition;