Tags / gaps-and-islands
Finding Gaps Between Timestamps for Multiple Entries in Data Analysis
Limiting Continuous Periods with SQL Window Functions
Aggregating Length of Time Intervals and Grouping to Fixed Time Grid: A Step-by-Step Solution
Optimizing Date Range Merging with Gaps-and-Islands Problem Solution