Today I was curious to find out about the days where most of the orders were placed.
If you want to find out about the same, use this SQL query:
SELECT COUNT(*) as orders_per_day, date(created_at) as day FROM sales_flat_order GROUP BY date(created_at) ORDER BY orders_per_day DESC