ZS Associates interview question

The question in Sql was about window functions