By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE
INSERT 0 10
| id | ts | session_id |
|---|---|---|
| 1 | 2022-08-01 09:00:00 | 1 |
| 1 | 2022-08-01 09:10:00 | 1 |
| 1 | 2022-08-01 09:12:00 | 1 |
| 1 | 2022-08-03 12:00:00 | 2 |
| 1 | 2022-08-03 12:03:00 | 2 |
| 2 | 2022-08-01 11:04:00 | 1 |
| 2 | 2022-08-01 11:07:00 | 1 |
| 2 | 2022-08-25 10:30:00 | 2 |
| 2 | 2022-08-25 10:35:00 | 2 |
| 2 | 2022-08-25 10:36:00 | 2 |
SELECT 10