Tiger Analytics Interview Question

SQL questions using windowing functions