Apple interview question

A SQL Question that requires a window function