Grant Street Group Interview Question

SQL question which involved using window functions