ادغام بازه‌های تاریخیِ هم‌پوشان

WITH ordered AS (
    SELECT *,
           MAX(end_date) OVER (
               ORDER BY start_date
               ROWS BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING
           ) AS prev_max_end
    FROM reservations
), flagged AS (
    SELECT *,
           CASE WHEN prev_max_end IS NULL
                  OR start_date > prev_max_end
                THEN 1 ELSE 0 END AS new_group
    FROM ordered
), grouped AS (
    SELECT *, SUM(new_group) OVER (ORDER BY start_date) AS grp
    FROM flagged
)
SELECT MIN(start_date) AS merged_start, MAX(end_date) AS merged_end
FROM grouped
GROUP BY grp
ORDER BY merged_start;