By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| Date_ | Person | Distance |
|---|---|---|
| 2022-01-01 | John | 15 |
| 2022-01-02 | John | 0 |
| 2022-01-03 | John | 0 |
| 2022-01-04 | John | 0 |
| 2022-01-05 | John | 19 |
| 2022-01-01 | Pete | 25 |
| 2022-01-02 | Pete | 12 |
| 2022-01-03 | Pete | 0 |
| 2022-01-04 | Pete | 0 |
| 2022-01-05 | Pete | 1 |
| Person |
|---|
| John |