Better interview question

SQL, With window functions. Guesstimates