Pregunta de entrevista de Infosys

They ask me the SQL Query on the Windows CTE and Subquery.