Gaps and Islands in SQL: Find Missing Numbers, Streaks and Status Runs
Gaps and islands in SQL: find missing invoice numbers with LEAD, consecutive ranges and login streaks with the ROW_NUMBER trick, runs of the same status with LAG and a running SUM, and missing dates with a calendar.








