By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ID1 | Date1 | Var1 | Group | Var2 | rn | ID2 | Date2 | VarZ | Group | rn |
|---|---|---|---|---|---|---|---|---|---|---|
| 20 | 2020-11-06 00:00:00 | 2 | A | 6 | 1 | 4 | 2022-01-15 00:00:00 | 2 | A | 1 |
| 23 | 2021-04-13 00:00:00 | 6 | B | 4 | 1 | 5 | 2019-08-02 00:00:00 | 6 | B | 1 |
| 22 | 2020-05-10 00:00:00 | 7 | C | 9 | 1 | 9 | 2021-05-02 00:00:00 | 7 | C | 1 |
| 25 | 2021-09-23 00:00:00 | 4 | C | 1 | 2 | 6 | 2021-12-29 00:00:00 | 2 | C | 2 |