I have an
orders table. Imagine it having only 2 columns,
Imagine I have a data in my
orders table that looks something like this:
id | created_at 01 | 2018-09-29 02 | 2018-09-29 03 | 2018-09-30
I want to select all orders within that day.
I can select the records you by using the following query.
SELECT created_at AS date, COUNT(id) AS result FROM orders GROUP BY created_at ORDER BY date
This will return:
date | result 2018-09-29 | 2 2018-09-30 | 1
I want to expand the query above to generate the following result instead: (daterange)
date | result 2018-09-15 | 0 2018-09-16 | 0 ... 2018-09-29 | 2 2018-09-30 | 1
Is this possible? To select a data that is non-existent to generate a date range report?