SELECT DAYOFMONTH(order_date) AS day_of_month, COUNT(*) AS order_count
FROM orders
GROUP BY day_of_month
ORDER BY day_of_month;