Postgres 10

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

WITH t1 AS (
SELECT 'A' AS id, 'created' AS status, '2021-07-15 10:30:00'::timestamp AS created_at UNION ALL
SELECT 'A' AS id, 'created' AS status, '2021-07-15 10:38:00'::timestamp AS created_at UNION ALL
SELECT 'A' AS id, 'missing_info' AS status, '2021-07-15 11:10:00'::timestamp AS created_at UNION ALL
SELECT 'A' AS id, 'missing_info' AS status, '2021-07-15 11:12:00'::timestamp AS created_at UNION ALL
SELECT 'A' AS id, 'pending' AS status, '2021-07-15 12:05:00'::timestamp AS created_at UNION ALL
SELECT 'A' AS id, 'missing_info' AS status, '2021-07-15 13:36:00'::timestamp AS created_at UNION ALL
SELECT 'A' AS id, 'missing_info' AS status, '2021-07-15 14:36:00'::timestamp AS created_at UNION ALL
SELECT 'A' AS id, 'pending' AS status, '2021-07-15 12:05:00'::timestamp AS created_at UNION ALL
SELECT 'A' AS id, 'successful' AS status, '2021-07-15 16:05:00'::timestamp AS created_at UNION ALL
SELECT 'A' AS id, 'successful' AS status, '2021-07-15 17:00:00'::timestamp AS created_at UNION ALL
SELECT 'B' AS id, 'created' AS status, '2021-07-16 10:30:00'::timestamp AS created_at UNION ALL
SELECT 'B' AS id, 'created' AS status, '2021-07-16 11:30:00'::timestamp AS created_at UNION ALL
SELECT 'B' AS id, 'successful' AS status, '2021-07-16 12:30:00'::timestamp AS created_at
    )
    
SELECT *
FROM t1

id	status	created_at
A	created	2021-07-15 10:30:00
A	created	2021-07-15 10:38:00
A	missing_info	2021-07-15 11:10:00
A	missing_info	2021-07-15 11:12:00
A	pending	2021-07-15 12:05:00
A	missing_info	2021-07-15 13:36:00
A	missing_info	2021-07-15 14:36:00
A	pending	2021-07-15 12:05:00
A	successful	2021-07-15 16:05:00
A	successful	2021-07-15 17:00:00
B	created	2021-07-16 10:30:00
B	created	2021-07-16 11:30:00
B	successful	2021-07-16 12:30:00