[extrememacaroni]

SQL is only secondary in my work but I'd rather go with the explicit and verbose queries rather than with stuff with surprises like how the last_value gives wrong results when used the way you'd expect i.e. the reverse of first_value.

[adilkhash]

if you understand the window ranges, especially the default one there is no surprise at all