SQLite Forum

How to convert to CTE
Login
Yes, typo was fixed.
Will see if I can explain in English the logic of the posted query that works.
Will also see if I can add indexes to speed things up.

RBS