unbounded preceding
unbounded following
num preceding 前num行
num following 后num行
current row 当前行
默认是sum(amount)rows between unbounded preceding and current row
93 93
188 281
16 297
20 317
同理
sum(amount)rows between unbounded preceding and unbounded following
93 317
188 317
16 317
20 317
同理
sum(amount)rows between 1 preceding and 1 following
93 281
188 297
16 224
20 36