Объединить 2 строки с одинаковым ID

Уже все решили,@Akina, я опоздал :)

CREATE TABLE orders (
id integer  PRIMARY KEY,
order_id TEXT ,
vzato_v_rabotu  DATETIME,
zakrito DATETIME
);

INSERT INTO orders VALUES (1, 'abcd', '2024-10-01 5:17:15',null);
INSERT INTO orders VALUES (2, 'abcd', null,'2024-10-01 10:05:16');
INSERT INTO orders VALUES (3, 'abcdf', '2024-10-01 9:17:15',null);
INSERT INTO orders VALUES (4, 'abcdf', null,'2024-10-01 12:05:16');


SELECT 
    order_id,
    MIN(vzato_v_rabotu) AS vzato_v_rabotu,
    MAX(zakrito) AS zakrito
FROM 
    orders
GROUP BY 
    order_id;

+----------+---------------------+---------------------+
| order_id | vzato_v_rabotu      | zakrito             |
+----------+---------------------+---------------------+
| abcd     | 2024-10-01 05:17:15 | 2024-10-01 10:05:16 |
| abcdf    | 2024-10-01 09:17:15 | 2024-10-01 12:05:16 |
+----------+---------------------+---------------------+

https://onecompiler.com/mysql/42y424juc