Comcast Interview Question

Write a SQL code using Partition by statement