Better Interview Question

SQL, With window functions. Guesstimates