Barclays interview question

Few question on SQL window functions