Pergunta de entrevista da empresa Bytecode IO

Q: Can you give an example of a Windows function in SQL and how you might use it?