MERGE INTO Final a
USING
(
SELECT a.*
  FROM (SELECT id
             , MIN(change_dtm) refilled_date
             , MAX(CASE WHEN Status != 'refilled' THEN change_dtm END) lastAction_date
             , SUM(CASE WHEN Status = 'dspsed' THEN 1 END) DSPSed
             , MIN(Checked) Checked
          FROM (SELECT ID, Status, change_dtm, Checked
                     , COUNT(CASE WHEN Status = 'refilled' THEN 1 END)
                       OVER(PARTITION BY ID ORDER BY change_dtm) grp
                  FROM History
                ) a
         GROUP BY id, grp
        ) a
  LEFT OUTER JOIN Final b
    ON a.id              = b.id
   AND a.refilled_date   = b.refilled_date
   AND ISNULL(a.lastAction_date, '') = ISNULL(b.lastAction_date, '')
   AND ISNULL(a.DSPSed         , -1) = ISNULL(b.DSPSed         , -1)
   AND ISNULL(a.Checked        , -1) = ISNULL(b.Checked        , -1)
 WHERE b.id IS NULL
) b
ON (a.id              = b.id
AND a.refilled_date   = b.refilled_date
)
WHEN MATCHED THEN
    UPDATE
	   SET a.lastAction_date = b.lastAction_date
         , a.DSPSed          = b.DSPSed
         , a.Checked         = b.Checked
WHEN NOT MATCHED THEN
    INSERT VALUES(b.id, b.refilled_date, b.lastAction_date, b.DSPSed, b.Checked)
;