By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| office_id | ts | cum_rev |
|---|---|---|
| 1 | 2022-01-01 00:00:00 | 100 |
| 1 | 2022-01-02 00:00:00 | 190 |
SELECT 2
| office_id | ts | cum_rev |
|---|---|---|
| 1 | 2022-01-01 00:00:00 | 100 |
| 1 | 2022-01-02 00:00:00 | 190 |
SELECT 2