Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
I'd like to get a list of orders per days. Sorted from most to least so that I can easily see on which days the most orders where placed.
A text report (SQL statement) is enough, I do not need a fancy report in the backend.
This statement can be used to retrieve a list of orders per day:
SELECT COUNT(*) as orders_per_day, date(created_at) as day
GROUP BY date(created_at)
ORDER BY orders_per_day DESC
Required, but never shown