By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| Building1 | Room1 | TimeOfDay1 | Direction1 | Building2 | Room2 | TimeOfDay2 | Direction2 | OccurrenceCount | Room1DirectionCount | Room2DirectionCount |
|---|---|---|---|---|---|---|---|---|---|---|
| BuildA | A1 | Morning | Up | BuildA | A2 | Morning | Up | 1 | 2 | 1 |
| BuildA | A1 | Morning | Up | BuildA | A2 | Morning | Down | 1 | 2 | 2 |
| BuildA | A1 | Morning | Up | BuildA | A2 | Evening | Up | 2 | 2 | 2 |
| BuildA | A1 | Morning | Up | BuildB | B1 | Morning | Up | 1 | 2 | 1 |
| BuildA | A1 | Morning | Up | BuildB | B1 | Morning | Down | 1 | 2 | 2 |
| BuildA | A1 | Morning | Up | BuildB | B1 | Evening | Up | 1 | 2 | 2 |
| BuildA | A1 | Morning | Up | BuildB | B1 | Evening | Down | 1 | 2 | 1 |
| BuildA | A1 | Morning | Up | BuildB | B2 | Morning | Unchanged | 1 | 2 | 1 |
| BuildA | A1 | Morning | Up | BuildB | B2 | Evening | Down | 1 | 2 | 1 |
| BuildA | A1 | Evening | Up | BuildA | A2 | Morning | Up | 1 | 1 | 1 |
| BuildA | A1 | Evening | Up | BuildA | A2 | Evening | Up | 1 | 1 | 2 |
| BuildA | A1 | Evening | Up | BuildB | B1 | Morning | Up | 1 | 1 | 1 |
| BuildA | A1 | Evening | Up | BuildB | B1 | Evening | Down | 1 | 1 | 1 |
| BuildA | A1 | Evening | Up | BuildB | B2 | Morning | Unchanged | 1 | 1 | 1 |
| BuildA | A1 | Evening | Up | BuildB | B2 | Evening | Down | 1 | 1 | 1 |
| BuildA | A1 | Evening | Down | BuildA | A2 | Morning | Down | 1 | 1 | 2 |
| BuildA | A1 | Evening | Down | BuildA | A2 | Evening | Up | 1 | 1 | 2 |
| BuildA | A1 | Evening | Down | BuildB | B1 | Morning | Down | 1 | 1 | 2 |
| BuildA | A1 | Evening | Down | BuildB | B1 | Evening | Up | 1 | 1 | 2 |
| BuildA | A2 | Morning | Up | BuildB | B1 | Morning | Down | 1 | 1 | 2 |
| BuildA | A2 | Morning | Up | BuildB | B1 | Evening | Up | 1 | 1 | 2 |
| BuildA | A2 | Morning | Down | BuildA | A1 | Morning | Up | 1 | 2 | 2 |
| BuildA | A2 | Morning | Down | BuildA | A1 | Evening | Down | 1 | 2 | 1 |
| BuildA | A2 | Morning | Down | BuildB | B1 | Morning | Up | 1 | 2 | 1 |
| BuildA | A2 | Morning | Down | BuildB | B1 | Evening | Down | 1 | 2 | 1 |
| BuildA | A2 | Morning | Down | BuildB | B2 | Morning | Unchanged | 1 | 2 | 1 |
| BuildA | A2 | Morning | Down | BuildB | B2 | Evening | Down | 1 | 2 | 1 |
| BuildA | A2 | Evening | Up | BuildB | B1 | Morning | Down | 1 | 2 | 2 |
| BuildA | A2 | Evening | Up | BuildB | B1 | Evening | Up | 1 | 2 | 2 |
| BuildA | A2 | Evening | Down | BuildA | A1 | Morning | Up | 1 | 1 | 2 |
| BuildA | A2 | Evening | Down | BuildA | A1 | Evening | Down | 1 | 1 | 1 |
| BuildA | A2 | Evening | Down | BuildB | B1 | Morning | Up | 1 | 1 | 1 |
| BuildA | A2 | Evening | Down | BuildB | B1 | Evening | Down | 1 | 1 | 1 |
| BuildA | A2 | Evening | Down | BuildB | B2 | Morning | Unchanged | 1 | 1 | 1 |
| BuildA | A2 | Evening | Down | BuildB | B2 | Evening | Down | 1 | 1 | 1 |
| BuildB | B1 | Morning | Up | BuildA | A2 | Morning | Down | 1 | 1 | 2 |
| BuildB | B1 | Morning | Up | BuildA | A2 | Evening | Up | 1 | 1 | 2 |
| BuildB | B1 | Morning | Down | BuildA | A1 | Morning | Up | 1 | 2 | 2 |
| BuildB | B1 | Morning | Down | BuildA | A1 | Evening | Down | 1 | 2 | 1 |
| BuildB | B1 | Morning | Down | BuildA | A2 | Morning | Up | 1 | 2 | 1 |
| BuildB | B1 | Morning | Down | BuildA | A2 | Evening | Up | 1 | 2 | 2 |
| BuildB | B1 | Morning | Down | BuildB | B2 | Morning | Unchanged | 1 | 2 | 1 |
| BuildB | B1 | Morning | Down | BuildB | B2 | Evening | Down | 1 | 2 | 1 |
| BuildB | B1 | Evening | Up | BuildA | A1 | Morning | Up | 1 | 2 | 2 |
| BuildB | B1 | Evening | Up | BuildA | A1 | Evening | Down | 1 | 2 | 1 |
| BuildB | B1 | Evening | Up | BuildA | A2 | Morning | Up | 1 | 2 | 1 |
| BuildB | B1 | Evening | Up | BuildA | A2 | Evening | Up | 1 | 2 | 2 |
| BuildB | B1 | Evening | Up | BuildB | B2 | Morning | Unchanged | 1 | 2 | 1 |
| BuildB | B1 | Evening | Up | BuildB | B2 | Evening | Down | 1 | 2 | 1 |
| BuildB | B1 | Evening | Down | BuildA | A2 | Morning | Down | 1 | 1 | 2 |
| BuildB | B1 | Evening | Down | BuildA | A2 | Evening | Up | 1 | 1 | 2 |
| BuildB | B2 | Morning | Up | BuildA | A1 | Morning | Up | 1 | 1 | 2 |
| BuildB | B2 | Morning | Up | BuildA | A1 | Evening | Down | 1 | 1 | 1 |
| BuildB | B2 | Morning | Up | BuildA | A2 | Morning | Up | 1 | 1 | 1 |
| BuildB | B2 | Morning | Up | BuildA | A2 | Evening | Up | 1 | 1 | 2 |
| BuildB | B2 | Morning | Up | BuildB | B1 | Morning | Up | 1 | 1 | 1 |
| BuildB | B2 | Morning | Up | BuildB | B1 | Evening | Down | 1 | 1 | 1 |
| BuildB | B2 | Morning | Unchanged | BuildA | A2 | Morning | Down | 1 | 1 | 2 |
| BuildB | B2 | Morning | Unchanged | BuildA | A2 | Evening | Up | 1 | 1 | 2 |
| BuildB | B2 | Morning | Unchanged | BuildB | B1 | Morning | Down | 1 | 1 | 2 |
| BuildB | B2 | Morning | Unchanged | BuildB | B1 | Evening | Up | 1 | 1 | 2 |
| BuildB | B2 | Evening | Up | BuildA | A1 | Morning | Up | 1 | 1 | 2 |
| BuildB | B2 | Evening | Up | BuildA | A1 | Evening | Down | 1 | 1 | 1 |
| BuildB | B2 | Evening | Up | BuildA | A2 | Morning | Up | 1 | 1 | 1 |
| BuildB | B2 | Evening | Up | BuildA | A2 | Evening | Up | 1 | 1 | 2 |
| BuildB | B2 | Evening | Up | BuildB | B1 | Morning | Up | 1 | 1 | 1 |
| BuildB | B2 | Evening | Up | BuildB | B1 | Evening | Down | 1 | 1 | 1 |
| BuildB | B2 | Evening | Down | BuildA | A2 | Morning | Down | 1 | 1 | 2 |
| BuildB | B2 | Evening | Down | BuildA | A2 | Evening | Up | 1 | 1 | 2 |
| BuildB | B2 | Evening | Down | BuildB | B1 | Morning | Down | 1 | 1 | 2 |
| BuildB | B2 | Evening | Down | BuildB | B1 | Evening | Up | 1 | 1 | 2 |