Complex cte query

Please refer