Domanda di colloquio di JPMorganChase

SQL: query which uses Windows function, group by etc