Pregunta de entrevista de Newton School

SQL question - (Joins & Window Function) Problem Solving