By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
18 rows affected
| Week | Time | max_direction_person | max_person_min_distance | second_max_direction_person | second_max_person_min_distance |
|---|---|---|---|---|---|
| 1 | 01:00:00.0000000 | C | 9 | B | 3 |
| 1 | 12:00:00.0000000 | A | 4 | B | 2 |
Warning: Null value is eliminated by an aggregate or other SET operation.