Numerator Interview Question

Describe how you would query a SQL database using WINDOW functions.