I have never explored a CTE before. Good new research and learning for me.

I will use the sub select as the new work around until I finish my learning on the CTE approach.

Thanks for you time everyone.