Great post Suraj! In my opinion, apart from what you have explained on CTE, it can provide a step-by-step algorithm as well for a data processing. E.g. The data must be group in a certain way before it can be ranked.