Domanda di colloquio di Infosys

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