SQLite Forum

How to convert to CTE
Login
It indeed needs to be all the dates in the range. Your query does give all dates but again gives the same wrong counts.
The basic query needs to be like mine, except with all dates in the range.

RBS