By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| GP | ID | DATE | CTC | CTC_SUM |
|---|---|---|---|---|
| AAAA | 001 | 2023-01-01 | 1 | 1 |
| AAAA | 002 | 2023-01-01 | 1 | 1 |
| AAAA | 003 | 2023-01-01 | 1 | 1 |
| AAAA | 004 | 2023-01-01 | 0 | 0 |
| AAAA | 001 | 2023-06-01 | 1 | 2 |
| AAAA | 002 | 2023-06-01 | 1 | 2 |
| AAAA | 005 | 2023-06-01 | 1 | 1 |
| AAAA | 006 | 2023-06-01 | 1 | 1 |