Pregunta de entrevista de Comcast

Write a SQL code using Partition by statement