Grant Street Group interview question

SQL question which involved using window functions