ARB Software interview question

CTE in sql