• I want to make a view from the query . will this CTE works for view.?