Best Query Approach

Thanks i tried this. As a result temp tables show multiple result and sum of all is less that cte time. So temp is better?