SELECT DAY(order_date) AS OrderDay, COUNT(*) AS TotalOrders
FROM orders
GROUP BY DAY(order_date);