SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE mytable (
  CreatedAt    datetime,                
  ID           int,
  NewStatus    varchar(30),
  OldStatus    varchar(30)
);

INSERT INTO mytable VALUES
('2023-03-08 13:34:57', 1645,    'Draft',        NULL),
('2023-03-22 19:58:51', 1645,    'Active',      'Draft'),
('2023-04-29 05:59:02', 1645,    'Closed' ,     'Active'),
('2023-05-08 14:50:29', 1645,    'Awarded',     'Closed'),
('2023-05-08 14:53:34', 1645,    'ConfirmationStarted', 'Awarded'),
('2023-05-08 17:53:55', 1645,    'ConfirmationDone',    'ConfirmationStarted');

INSERT INTO mytable VALUES
('2022-05-25 23:17:44', 147, 'Active',  'Closed'),
('2022-05-28 05:59:02', 147, 'Closed',  'Active'),
('2022-05-30 20:48:53', 147, 'Active',  'Closed'),
('2022-06-18 05:59:01', 147, 'Closed',  'Active'),
('2022-06-21 20:09:48', 147, 'Active',  'Closed'),
('2022-06-25 05:59:01', 147, 'Closed',  'Active'),
('2022-07-13 00:02:47', 147, 'ConfirmationStarted', 'Closed'),
('2022-07-15 15:33:30', 147, 'ConfirmationDone',    'ConfirmationStarted');

14 rows affected

ID	xdate
147	2022-06-25 05:59:01.000
1645	2023-04-29 05:59:02.000

Warning: Null value is eliminated by an aggregate or other SET operation.