这可以通过自我（反）联接来实现：
SELECt a.*FROM (SELECt name, dt, SUM(score) as sum_score FROM performance GROUP BY name, dt) aJOIN (SELECt name, dt, SUM(score) as sum_score FROM performance GROUP BY name, dt) bON a.name = b.name AND a.sum_score = b.sum_score AND a.dt < b.dt
