SQL Server 2014

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

CREATE TABLE data
    ([TYPE] varchar(3), [A] int, [B] int, [C] datetime)
;
    
INSERT INTO data
    ([TYPE], [A], [B], [C])
VALUES
    ('aaa', 5, 6, '2022-05-01 00:00:00'),
    ('aaa', 8, 7, '2022-05-08 00:00:00'),
    ('aaa', 9, 8, '2022-05-16 00:00:00'),
    ('bbb', 7, 4, '2022-05-09 00:00:00'),
    ('bbb', 6, 8, '2022-05-14 00:00:00'),
    ('bbb', 3, 3, '2022-05-25 00:00:00')
;
6 rows affected

SELECT DISTINCT TYPE,
  SUM(A) OVER(PARTITION BY TYPE) AS A,
  FIRST_VALUE(B) OVER(PARTITION BY type ORDER BY C DESC) AS D,
  MAX(C) OVER(PARTITION BY TYPE) AS C
FROM data;


TYPE
A
D
C


aaa
22
8
2022-05-16 00:00:00.000

bbb
16
3
2022-05-25 00:00:00.000


DROP TABLE data;