Optimizing Session Duration Calculation in Postgres with Recursive CTEs and Joins

How to Master Recursive Querying with Common Table Expressions (CTEs) in SQL Server