Tags / gaps-and-islands
Identifying Potential Entry and Exit Rows in SQL Server Using CTEs
Identifying Consecutive Vacant Seats in MySQL: A Comprehensive Approach
Selecting Sportsmen in Oracle SQL: Approaches and Limitations for Consecutive Competitions
Finding Gaps Between Timestamps for Multiple Entries in Data Analysis