Bungee Interview Question

Basic SQL question with window function