You have seen ORDER BY inside a window decide a numbering. Put it inside an aggregate's window and something new happens: the aggregate stops summarising the whole window, and each row gets the total so far. Badges earned in the league, in date order: