Magento: Get daily sales order counts

This simple MySQL query gets the daily order counts from Magento in Jan 2014.
[code language=”sql”]
SELECT DATE(created_at) AS DATE, count(DATE(created_at)) AS order_count
FROM sales_flat_order
WHERE created_at BETWEEN ‘2014-01-01’ AND ‘2014-02-01’
GROUP BY DATE(created_at);
[/code]