HSBC Interview Question

How and where cte is useful