MySQL: adding days with zero orders to the list of orders per day
is a table of orders then no. The query will not create rows / data that does not already exist in the database. If there are no order records for a specific day, you will not receive that exit date.
You can create a temporary table containing each date in a specific range and join it - then you really have all the dates you need and you get a 0-ordinal score for quiet days.
source to share