Netflix Interview Question

SQL questions on Partitioning and Aggregate.