why we are using CTE?

Question

Hi All,

 

 

why we are using cte?

and when we are using it?

 

Thanks All