Pregunta de entrevista de Bungee

Basic SQL question with window function