Windowing functions are a great way of letting a row be aware of what’s going on around it – not just in the current row, but in all its neighbors.