SQL Server 2019

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

select @@version;


(No column name)


Microsoft SQL Server 2019 (RTM-CU16) (KB5011644) - 15.0.4223.1 (X64) 
 Apr 11 2022 16:24:07 
 Copyright (C) 2019 Microsoft Corporation
 Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)



create table t1 (
id varchar(4),
type varchar(3),
time datetime
);

insert into t1 values
('Q001',	'In',	'2022-8-30 08:30:00'),
('Q001',	'Out',	'2022-8-30 10:35:00'),
('Q001',	'In',	'2022-8-30 10:42:00'),
('Q001',	'Out',	'2022-8-30 12:15:00');
4 rows affected

SELECT
    id,
    MIN(time) AS "in",
    MAX(time) AS out
FROM (
    SELECT
        *,
        ROW_NUMBER() OVER (PARTITION BY type ORDER BY time) rn
    FROM t1
) t
GROUP BY id, rn


id
in
out


Q001
2022-08-30 08:30:00.000
2022-08-30 10:35:00.000

Q001
2022-08-30 10:42:00.000
2022-08-30 12:15:00.000


SELECT
    id,
    (SELECT 
         MAX(time) 
     FROM t1 t_in
     WHERE t_in.id = t1.id 
           AND t_in.type = 'In'
           AND t_in.time < t1.time
    ) "in",
    time "out"
FROM t1
WHERE type = 'Out'


id
in
out


Q001
2022-08-30 08:30:00.000
2022-08-30 10:35:00.000

Q001
2022-08-30 10:42:00.000
2022-08-30 12:15:00.000

id	in	out
Q001	2022-08-30 08:30:00.000	2022-08-30 10:35:00.000
Q001	2022-08-30 10:42:00.000	2022-08-30 12:15:00.000