Pergunta de entrevista da empresa Grant Street Group

SQL question which involved using window functions