假设有以下数据:
| time | id | score | 
| 1 | 1 | 4 | 
| 12 | 2 | 3 | 
| 33 | 3 | 3 | 
| 45 | 4 | 5 | 
| 55 | 1 | 5 | 
| 67 | 3 | 4 | 
| 87 | 5 |  | 
| 88 | 6 | 1 | 
| 89 | 2 | 2 | 
| 120 | 3 | 3 | 
time是solution的提交时间,id是solution编号,score是对solution的评分。评阅人可以重复对相同solution评分,如solution1 在time=1和time=55时被分别评分4和5。现想根据此实时评分结果输出累计得分数,如下:
| time | id | score | accumulate_1 | accumulate_2 | accumulate_3 | accumulate_4 | accumulate_5 | 
| 1 | 1 | 4 | 0 | 0 | 0 | 1 | 0 | 
| 12 | 2 | 3 | 0 | 0 | 1 | 1 | 0 | 
| 33 | 3 | 3 | 0 | 0 | 2 | 1 | 0 | 
| 45 | 4 | 5 | 0 | 0 | 2 | 1 | 1 | 
| 55 | 1 | 5 | 0 | 0 | 2 | 0 | 2 | 
| 67 | 3 | 4 | 0 | 0 | 1 | 1 | 2 | 
| 87 | 5 |  | 0 | 0 | 1 | 1 | 2 | 
| 88 | 6 | 1 | 1 | 0 | 1 | 1 | 2 | 
| 89 | 2 | 2 | 1 | 1 | 0 | 1 | 2 | 
| 120 | 3 | 3 | 1 | 1 | 1 | 0 | 2 | 
难点在于,有些solution是被重复打分的,后面的打分会覆盖前面的打分信息,且要根据新的打分信息更新累计数,即原来的得分的累计数要减一,新的得分的累计数要加一。请教各位如何实现?谢谢大家。