Gaps and islands

The LAG-and-SUM streak query keeps its gap rule in one editable CASE line

SQL makes you assemble streaks by hand, so a dev.to walkthrough builds three from ROW_NUMBER, LAG and a running SUM. What separates them is where the definition of a gap gets written, and how hard it is to change later.