WITH a AS (      SELECT 1 AS id, CAST('2024-09-13 09:00:00' AS DATETIME) AS tm      UNION ALL      SELECT 2, CAST('2024-09-13 12:05:00' AS DATETIME)      UNION ALL      SELECT 3, CAST('2024-09-13 13:50:00' AS DATETIME)      UNION ALL      SELECT 4, CAST('2024-09-13 14:15:00' AS DATETIME)      UNION ALL      SELECT 5, CAST('2024-09-13 14:20:00' AS DATETIME)      UNION ALL      SELECT 6, CAST('2024-09-13 18:45:00' AS DATETIME)   ),   b AS (      SELECT          id,          tm,          LAG(tm) OVER (ORDER BY id) AS prev_tm      FROM          a   ),   c AS (      SELECT          id,          tm,          prev_tm,          CASE              WHEN CAST(prev_tm AS TIME) <= '12:40:00' AND CAST(tm AS TIME) >= '13:40:00' THEN                  DATEDIFF(MINUTE, CAST(prev_tm AS DATETIME), CAST('13:40:00' AS DATETIME))                  + DATEDIFF(MINUTE, CAST('14:00:00' AS DATETIME), tm)              WHEN CAST(prev_tm AS TIME) > '12:40:00' AND CAST(prev_tm AS TIME) < '13:40:00' THEN                  DATEDIFF(MINUTE, CAST('14:00:00' AS DATETIME), tm)              ELSE                  DATEDIFF(MINUTE, prev_tm, tm)          END AS adjusted_time_diff      FROM          b   )   SELECT      id,      tm,      prev_tm,      adjusted_time_diff   FROM      c   ORDER BY      id;