Pergunta de entrevista da empresa Barclays

Few question on SQL window functions