Pergunta de entrevista da empresa PPL

SQL Question regarding use of Joins, with window queries