Pergunta de entrevista da empresa noon

more question on window functions and join logic