Pergunta de entrevista da empresa Comcast

Write a SQL code using Partition by statement