Window Function Nested in a Window ORDER BY

Company: Eternal_29sep

Difficulty: medium