Explain how window functions differ from standard GROUP BY operations, and provide an example of when to use them.