Bungee interview question

Basic SQL question with window function