Pregunta de entrevista de Netflix

SQL questions on Partitioning and Aggregate.