Using Select Statement Result as Variable and Passing it to CTE and Union All Results from CTE

Optimizing SQL with CTEs: A Step-by-Step Guide to Efficient Querying