Find the total number of orders placed in each unique date name (e.g., monday, tuesday).

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