Comcast interview question

Write a SQL code using Partition by statement