JPMorganChase interview question

SQL: query which uses Windows function, group by etc