• I think the point of the question is that unless you know how windowed aggregation works, it is a gotcha.