如何在SQL Server中对按重叠时间分组的持续时间求和

CREATE TABLE time_periods (
    start_time datetime,
    end_time datetime
);

INSERT INTO time_periods (start_time, end_time)
VALUES
    ('2022-01-01 08:00:00', '2022-01-01 10:00:00'),
    ('2022-01-01 09:00:00', '2022-01-01 11:00:00'),
    ('2022-01-01 10:00:00', '2022-01-01 12:00:00'),
    ('2022-01-01 11:00:00', '2022-01-01 13:00:00');

WITH grouped_periods AS (
    SELECT start_time, end_time, DATEDIFF(minute, start_time, end_time) AS duration
    FROM time_periods
)
SELECT start_time, end_time, duration,
       SUM(duration) OVER (PARTITION BY NULL) AS total_duration
FROM grouped_periods;