Splitting a Column Value into Two Separate Columns in MySQL Using Window Functions

Handling Missing Primary Keys for Derived Columns: The LAG/LEAD Puzzle in SQL Server 2012

Creating Time Windows with Alternating Values in T-SQL

Grouping Consecutive Rows Based on One Column Using SQL Row Number Functions