By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
11 rows affected
| Key1 | Date1 | Name1 | Location1 | grp | Rank1 |
|---|---|---|---|---|---|
| 20 | 2021-12-30 | Ann | Site A | 0 | 1 |
| 23 | 2021-12-31 | Ann | Site A | 0 | 2 |
| 26 | 2022-01-03 | Ann | Site A | 1 | 1 |
| 28 | 2022-01-04 | Ann | Site A | 1 | 2 |
| 29 | 2022-01-05 | Ann | Site A | 1 | 3 |
| 32 | 2022-01-06 | Ann | Site A | 1 | 4 |
| 62 | 2022-01-08 | Ann | Site A | 2 | 1 |
| 63 | 2022-01-10 | Ann | Site A | 3 | 1 |
| 64 | 2022-01-11 | Ann | Site A | 3 | 2 |
| 65 | 2022-01-12 | Ann | Site A | 3 | 3 |
| 66 | 2022-01-13 | Ann | Site A | 3 | 4 |